topic Re: How to ignore selection in QlikView

How to ignore selection

d4rlie891 — Tue, 16 Aug 2016 03:40:08 GMT

Hi,

Anyone can help me, how to Ignore Year_Month Selection for this Set Analysis :

Max(Aggr(

sum({<YEAR_MONTH = {">=$(=date(addmonths(max({1}YEAR_MONTH), -12), 'YYYY-MM'))"} * {"<=$(=max({1}YEAR_MONTH))"}, JENIS_TRX>}TOT_TRANS),TANGGAL))

So if I do select the YEAR_MONTH, the Chart below will not change.

I also doesn't want this KPI changed by YEAR_MONTH Selection

FirstSortedValue(DISTINCT TANGGAL, -Aggr(sum(TOT_TRANS),TANGGAL))

Thanks for you help.

arulsettu — Tue, 16 Aug 2016 07:25:36 GMT

can you post sample qvf

jonathandienst — Tue, 16 Aug 2016 07:28:52 GMT

Put an override for YEAR_MONTH before the Aggr():

Max({<YEAR_MONTH>}

Aggr(

Sum({<

YEAR_MONTH = {">=$(=date(addmonths(max({1}YEAR_MONTH), -12), 'YYYY-MM'))"}

* {"<=$(=max({1}YEAR_MONTH))"}, JENIS_TRX>}TOT_TRANS)

,TANGGAL))

jonathandienst — Tue, 16 Aug 2016 07:30:15 GMT

And

FirstSortedValue({<YEAR_MONTH>} DISTINCT TANGGAL, -Aggr(sum(TOT_TRANS),TANGGAL))

d4rlie891 — Tue, 16 Aug 2016 09:17:43 GMT

Thanks So Much, It's Worked