topic Re: Showing a Quarter's Total Based on Month Selection in QlikView

Showing a Quarter's Total Based on Month Selection

Tue, 16 Feb 2016 21:26:02 GMT

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!

Re: Showing a Quarter's Total Based on Month Selection

maxgro — Tue, 16 Feb 2016 21:50:20 GMT

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

Re: Showing a Quarter's Total Based on Month Selection

sunny_talwar — Tue, 16 Feb 2016 21:50:35 GMT

Try this:

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

Re: Showing a Quarter's Total Based on Month Selection

Tue, 16 Feb 2016 21:54:59 GMT

This works! Thank you!

Re: Showing a Quarter's Total Based on Month Selection

sunny_talwar — Tue, 16 Feb 2016 23:06:48 GMT

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