# qlik-expressions

> Claude/Codex skill by [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars · Updated 2026-05-18

Set analysis syntax and patterns, aggregation functions, TOTAL qualifier usage, Aggr() patterns, conditional expressions, null handling in expressions, dollar-sign expansion, expression performance optimization, calculation conditions, and common anti-patterns for Qlik Sense expression development. Load when writing or reviewing Qlik expressions.

## Install

```sh
git clone https://github.com/Pupfish-LLC/qlik-agents /tmp/qlik-agents && ln -s /tmp/qlik-agents/skills/qlik-expressions ~/.claude/skills/qlik-expressions
```

## From README

Qlik Sense Expressions Expressions evaluate in the USER's selection context, not in a script context. A chart object displays data based on what the user has selected in filter panes, listboxes, and other selection controls. Set analysis is the mechanism for overriding that selection context programmatically. Expression bugs almost always stem from misunderstanding selection scope. Set analysis is where the confusion begins. This skill covers aggregation functions, set analysis syntax and patterns, the TOTAL qualifier, the Aggr() function, conditional expressions, null handling, dollar-sign expansion, calculation conditions, expression performance, and anti-patterns. Aggregation Functions and Null Behavior All Qlik aggregation functions skip NULL values by default. This is correct behavior but the consequences are easy to miss. Core aggregation functions: Sum(Field) — Sums non-NULL values. Sum(\[1, NULL, 3\]) = 4. If all values are NULL, returns NULL (not 0).

## Links

- HTML page: https://omgskills.com/library/pupfish-llc/qlik-agents/skills/qlik-expressions/
- GitHub: https://github.com/Pupfish-LLC/qlik-agents
- Author: [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md)

## More from this repo

- [data-quality-validator](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/data-quality-validator/index.md) — Post-load data quality validation patterns for Qlik development.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars
- [platform-conventions](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/platform-conventions/index.md) — Captures existing platform patterns for brownfield Qlik projects.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars
- [qlik-cloud-mcp](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/qlik-cloud-mcp/index.md) — Capability registry for the Qlik Cloud MCP server.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars