Ignoring filter selection in set analysis

[Anonymous]

Hi

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

g

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

[MK_QSL]

Try

=Sum({

1<

[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

[Anonymous]

Tanq u so much..Its working now

[MK_QSL]

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/