Showing a Quarter's Total Based on Month Selection

[#1]

Hello,

I am trying to find a way to use the data from an entire quarter in the chart calculation based only on a month selection. For instance, if i have February 2016 selected as my filter, I would like the chart to display data from January, February, and March of 2016. If I select April 2016, I would like the chart to display data from April, May, and June of 2016. Is there a way to do this in the expression of the chart?

Below is a similar post that remained unanswered.

Set Analysis and Quarter selection?!?! | Qlik Community

Thanks for your help!

[maxgro · Accepted solution]

I think you can use a calendar with a quarter field and a set analysis that disregard the month selected and use the quarter

something like

sum({$ <Month=,Quarter=P(Quarter)>}  measure)

EDIT

see the attachment

[sunny_talwar]

Try this:

Sum({<MonthYear, Quarter = p(Quarter)>}Sales)

[#4]

This works! Thank you!

[sunny_talwar]

If you got what you were looking for, please close this thread by marking correct and helpful answers

Qlik Community Tip: Marking Replies as Correct or Helpful