Set analysis. Modifier as expression

[MindaugasBacius]

Good evening,

Is it possible in Set analysis Set modifier as an expression?

My set analysis sentence looks like this SUM({1<Year = {2012}>}VILNIUS).

Can I modify value 2012 like to MAX(Year) or so?

Thank you in advance

[sunny_talwar · Accepted solution]

Yes you can. Try this:

=Sum({1<Year = {"$(=Max(Year))"}>}VILNIUS) or

=Sum({1<Year = {"$(=Max({1}Year))"}>}VILNIUS) if you want the max year to be always the max regardless of any selections.

HTH

Best,

Sunny

[maxgro]

pag. 10 of pdf

Set Analysis: syntaxes, examples

or in Qlik help