Qlik Community

Qlik Sense App Development

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

joshpinfoldold
New Contributor III

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)

3 Replies
shraddha_g
Honored Contributor III

Re: Count from the month before selection

Try

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

joshpinfoldold
New Contributor III

Re: Count from the month before selection

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
Honored Contributor III

Re: Count from the month before selection

If possible share sample app n sample data

Community Browser