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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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
sunny_talwar

Not sure why it is still changing, would you be able to share a sample to look at?