topic Re: Ignore Selection for Max Avg in QlikView

Ignore Selection for Max Avg

d4rlie891 — Thu, 18 Aug 2016 01:57:21 GMT

Hi,

anyone can help me, I need to ignore the DAY selection from my Set Analysis.

I only have data on Day 1. If someone click the DAY other than DAY 1, I want this KPI keep showing the Value.

The point is, I want to Ignore the DAY selection.

These are my Set Analysis :

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

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

Thanks

Re: Ignore Selection for Max Avg

sunny_talwar — Thu, 18 Aug 2016 08:19:21 GMT

May be this:

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

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

Re: Ignore Selection for Max Avg

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

Hi Sunny,

It's Worked,

But I am still not fully understand about the logic of this Set Analysis.

Could you give me some explanation about this logic.

Thanks so much.

Re: Ignore Selection for Max Avg

sunny_talwar — Thu, 18 Aug 2016 10:27:39 GMT

Basically telling the expression to ignore selection in DAY in every possible Aggregation function that I see in those two expression.

Min, Max, Sum, Avg, FirstSortedValue, Only, Median...... Everywhere you see these, you will have to add a set analysis to ignore selection in DAY. This can be done like this {<DAY>} or {<DAY = >}

Re: Ignore Selection for Max Avg

d4rlie891 — Thu, 18 Aug 2016 10:33:17 GMT

Thanks again for your information.