topic Ignoring filter selection in set analysis in QlikView

Ignoring filter selection in set analysis

Anonymous — Tue, 13 Mar 2018 14:06:04 GMT

I have a filter condition but i don't want my below set analysis changes depends on the filter selection.

This is what i tried...but its not working out

=Sum({1<[PROCESSED_DT.autoCalendar.Date]={">=$(=YearStart(Max([PROCESSED_DT.autoCalendar.Date])))<=$(=WeekEnd(Max([PROCESSED_DT.autoCalendar.Date]),-1))"},

[Rollover_Activity_Only.ROLLOVER_DESTINATION_TXT]={'RTF'}>}

[Rollover_Activity_Only.ROLLED_TO_AMT])/1000000

The data's are getting changed depends on the filter selection.

Re: Ignoring filter selection in set analysis

MK_QSL — Tue, 13 Mar 2018 14:13:13 GMT

Try

=Sum({

[PROCESSED_DT.autoCalendar.Date]={">=$(=YearStart(Max({1}[PROCESSED_DT.autoCalendar.Date])))<=$(=WeekEnd(Max({1}[PROCESSED_DT.autoCalendar.Date]),-1))"},

[Rollover_Activity_Only.ROLLOVER_DESTINATION_TXT]={'RTF'}>}

[Rollover_Activity_Only.ROLLED_TO_AMT])/1000000

Re: Ignoring filter selection in set analysis

Anonymous — Tue, 13 Mar 2018 14:17:31 GMT

Tanq u so much..Its working now

Re: Ignoring filter selection in set analysis

MK_QSL — Tue, 13 Mar 2018 14:24:41 GMT

Great. Now close the thread by selecting correct answer..

If you want to learn more about set analysis, try my course from udemy.

https://www.udemy.com/become-an-expert-of-qlik-set-analysis/