Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Rogers2212
Contributor II
Contributor II

Getting the previous months sum of data but ignoring the filter that has been selected

Hi, I have a dashboard and it can be filtered by month. I get a sum in a KPI box and next to the box i want to show what the previous months volume is. 

I have used the below and modified it from another post however it only returns the same months volume. Any Ideas as to what i am doing wrong?

Sum({<call_date = {">=$(=MonthStart(AddMonths(Max(call_date), -1)))<=$(=MonthEnd(AddMonths(Max(call_date), -1)))"}>} totalcalls)

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

@Rogers2212 May be this... make sure to ignore selection in MonthField because that will conflict with your set analysis unless you tell you expression to ignore selection in MonthField

Sum({<call_date = {">=$(=MonthStart(Max(call_date), -1))<=$(=Date(Floor(MonthEnd(Max(call_date), -1))))"}, MonthField>} totalcalls)

 

View solution in original post

1 Reply
sunny_talwar

@Rogers2212 May be this... make sure to ignore selection in MonthField because that will conflict with your set analysis unless you tell you expression to ignore selection in MonthField

Sum({<call_date = {">=$(=MonthStart(Max(call_date), -1))<=$(=Date(Floor(MonthEnd(Max(call_date), -1))))"}, MonthField>} totalcalls)