Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis help

Hi Friends,

I have the following expression which works as expected. However I don't want it to respond to MONTH selections. Now when I click on any month it still filters to show only that month. Please help!

aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1)),MONTH)



Thanks,

Weiting

10 Replies
vinieme12
Champion III
Champion III

Try

aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

May be this:

Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, MONTH-1)), MONTH))

Not applicable
Author

Thanks Sunny,

I added only function as you suggested but it's doing the same thing... When I filter on any month, it's only showing me that month data point versus the whole year..

Any other ideas?

Weiting

sunny_talwar

I see the issue now, try this:

Only({<MONTH>}Aggr(RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'}, MONTH=>} COMBO_NEW_GOAL_VALUE), 1, Only({<MONTH>} MONTH)-1)), MONTH))

vinieme12
Champion III
Champion III

have you tried the below

aggr(only({<MONTH>}RangeSum(ABOVE(SUM({1<KPI_NAME={'$(vKPIChecking)'},MONTH=>}COMBO_NEW_GOAL_VALUE),1,MONTH-1))),MONTH)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Hi Vineeth,

Thanks for the reply. Yes I tried your approach and it doesn't work...

Any other ideas please?

Not applicable
Author

Still filtering on month...

Not sure what's going on...

sunny_talwar

How do you define vKPIChecking?

Not applicable
Author

vKPIChecking= 'New Checking Accounts'