Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

show last 6 quarters

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.

Community Browser