topic Calculation inside Set analysis in QlikView

Calculation inside Set analysis

Thu, 28 Aug 2014 07:49:20 GMT

Hello,

is it possible to calculate inside set alaysis?

For example:

Column1 --> count (Distinct {<Stat = {ER}, Filter_DatYYYY = {2014} >} [No_])

Column 2 should be --> count (Distinct {<Stat = {ER}, Filter_DatYYYY = {2013} >} [No_])

so it should be Filter_DatYYYY = {2014} minus 1

Beste Regards

Georg

Anonymous — Thu, 28 Aug 2014 07:54:59 GMT

you can calculate within set analysis

e.g. with today

Filer_datYYYY={$(=year(today)-1)}

MK_QSL — Thu, 28 Aug 2014 08:14:53 GMT

count (Distinct {<Stat = {ER}, Filter_DatYYYY = {'$(=Max(Filter_DatYYYY )-1)'} >} [No_])

Thu, 28 Aug 2014 08:27:30 GMT

thx a lot!

Thu, 28 Aug 2014 08:27:40 GMT

thx a lot!