Discussion Board for collaboration related to QlikView App Development.
Can some one help for below question.
I have Quarter Field and values is like below
Q118, Q218, Q318, Q418, Q119, Q219,Q319
But now i want to write in a script to get a new field for Quarter for that what i needs is
First point: always it should give latest 5 rolling Quarters , means in this example it should give me
Q318, Q418, Q119, Q219,Q319
but again Q319 is not completed Quarter so i should not get Q319 till Quarter completes.
Quarte completes means
i have month filed like values below
(201811, 201812, 201901 ) ----Q119
(201902, 201903, 201904 )----- Q219
(201905, 201906, 201907 )----- Q319
so in my report max month now is 201905 , so till i get 201907 month value in my report i should not see Q319, till that my last five Quarters should be
Q218, Q318, Q418, Q119, Q219 for that i need to write a script and derive a field in load script .
how can we write that.
Not Required i did at front end by creating Variables.
View solution in original post