topic Set analysis. Modifier as expression in QlikView

Set analysis. Modifier as expression

MindaugasBacius — Fri, 24 Jul 2015 20:03:27 GMT

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 — Fri, 24 Jul 2015 20:12:23 GMT

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 — Fri, 24 Jul 2015 20:15:33 GMT

pag. 10 of pdf

or in Qlik help