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: 
Not applicable

Showing a Quarter's Total Based on Month Selection

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!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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



View solution in original post

4 Replies
maxgro
MVP
MVP

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)

Not applicable
Author

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