Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count from the month before selection

Trying to show the volume of feedback received in the month previous to the one that is selected via a filter pane. Eg if September '17 is selected I would like the volume of feedback from August '17. Currently the following is not working;

Count({1<Feedback_Day_Start = {">=$(=monthstart(addmonths(max(Feedback_Day_Start), -1)))"},

Feedback_Day_Start = {"<=$(=monthend(addmonths(max(Feedback_Day_Start), -1)))"}>} FeedbackFlag)

Labels (1)
3 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try

Count ({<Feedback_Day_Start ={">=$(=monthstart(addmonths(max(Feedback_Day_Start),-1))) <=$(=monthend(addmonths(max(Feedback_Day_Start),-1)))"}>}  FeedbackFlag)

Anonymous
Not applicable
Author

Yes I did try combining them into a single set but it returns '0' for each value which i know not to be the case.

shraddha_g
Partner - Master III
Partner - Master III

If possible share sample app n sample data