topic How to Ignore Day Selection in QlikView

How to Ignore Day Selection

d4rlie891 — Thu, 18 Aug 2016 08:18:20 GMT

Hi,

Anyone can help me how to Ignore DAY Selection from these Set Analysis ?

I have two set analysis :

1. Max(Aggr(Avg({$<YEAR_MONTH = {"$(=max(YEAR_MONTH))"}, ONL_BTC = {"BTC"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}>}ESAP),DT))

2. FirstSortedValue(DT, -Aggr(Avg({< ONL_BTC = {"BTC"}, YEAR_MONTH = {"$(=max(YEAR_MONTH))"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}>} ESAP), DT))

I want the Value of Max AVG CPU 1 (21.90) and DT Max Avg CPU (15 Jun 2016) are not Change, when I click the number of DAY

Right now the value of those KPI, are changed when I click the DAY.

Thanks

Re: How to Ignore Day Selection

sunny_talwar — Thu, 18 Aug 2016 08:26:50 GMT

See if my response here helps: Ignore Selection for Max Avg

Re: How to Ignore Day Selection

Anonymous — Thu, 18 Aug 2016 09:27:15 GMT

1. Max(Aggr(Avg({$<YEAR_MONTH = {"$(=max(YEAR_MONTH))"}, ONL_BTC = {"BTC"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}, DAY=>}ESAP),DT))

2. FirstSortedValue(DT, -Aggr(Avg({< ONL_BTC = {"BTC"}, YEAR_MONTH = {"$(=max(YEAR_MONTH))"}, WEEKDAY-={'Sun','Sat'}, HOLIDAY_FLG={'N'}, DAY=>} ESAP), DT))