Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
mbn
Contributor
Contributor

Using parameterised expression with outer set expression

I have the following construct

1. set analysis is stored in a variable. This expression is parameterized so i can reuse it across multiple fields

2. the variable is used in a master measure

3. the master measure is used in a viz object and i apply additional filters to it with out set expression

Example:

vVariable: sum({<Date= {'$(MaxDate)'}, $2, $3>} $1)

Measure = $(vVariable(Field1))

Viz object expression: {<Field2 = {a,b,c}>} Measure

The problem is that this construct is not filtering my Measure according to Field2 scope. However, if I add Field2 into the base measure, I get an expected result - e.g., Measure = $(vVariable(Field1, Field2 = {a,b,c}))

Is there a limitation to using parameterised expressions with outer set expressions?

Labels (6)
0 Replies