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

show last 6 quarters

Hi,

I want to show the last 6 quarters in a pivot table.

Is it possible to make this dynamic? So when I open the document now I see Q1 2011, Q4 2010, Q3 2010, Q2 2010, Q1 2010, Q4 2009 but when I open the same document next month I want to see: Q2 2011, Q1 2011, Q4 2010, Q3 2010, Q2 2010, Q1 2010

Can anyone help me with this issue?

1 Reply
Miguel_Angel_Baeyens

Hello Elke,

Check the attached document. The idea is that you have a master calendar with all fields related to dates, and Quarter being one of them, you can easily say you want to show sales starting n months ago.

Hope this helps.