· Qlik Sense
Outer set expressions in Qlik Sense: one set for the whole expression
Inner and outer set expressions, chained sets, the & flag, dollar-sign expansion and master measures: recent set analysis syntax, checked in Qlik Cloud.
[ blog ] · 11 articles
Tag: Expressions
· Qlik Sense · Series · 8 articles
Lesser-known Qlik Sense functions and keywords: a series
Aggr, set analysis, dollar expansion, Window, CrossTable, Generic, Semantic, Merge, Dual: a series on lesser-known Qlik Sense functions.
- Aggr() in Qlik Sense: the virtual table and its four pitfalls
- Advanced set analysis in Qlik Sense: P(), E(), operators and searches
- Dollar-sign expansion in Qlik Sense: $(var), $(=…), $(#…) and parameters
- Above, Below, RangeSum: inter-record functions in Qlik Sense charts
- Dual() and the dual nature of values in Qlik Sense
- FirstSortedValue, Concat, Only, Rank: lesser-known Qlik Sense aggregations
- ValueLoop and ValueList: synthetic dimensions in Qlik Sense
- Class, Match, WildMatch, Pick: banding and mapping without a lookup table
· Qlik Sense
NULL, zero, empty string: handling missing values in Qlik Sense
NULL, empty strings, missing values: how Qlik Sense handles nothing in the script, in visualizations and in set analysis, and how to make it selectable.