When i Open a sheet always latest 5 Quarters should be selected in my Qlikview Report , how can we do it?
my Quarter field is FY_QYM
in that values is as per below
You will have to apply a numeric value (straight numbering or a date-value) to the string denominating the quarter.
Subject to this you will have to create a trigger on document open to select the topmost 5 values.
See a simple example in the attached file - think that you will catch the point.
Check if that helps
Before open yours, Have you attempted mine?
Yes i tried yours as well. but not able to.
one more point is when you do rank always it should take latest 5 quarters means Q4FY17, Q1FY18, Q2FY18, Q3FY18 and Q4FY18.
I have created a Rolling 5 Quarters variable in my attached app. but when i try to pass it to sheet open trigger it is not taking it.