Discussion Board for collaboration on QlikView Scripting.
In our current Requirement we want to design period over period data .
our period code is like ;
P1 to P13
P1 start from 22/04/2015 to 19/05/2015 and P13 is 25/03/2016 to 21/04/2016...
Now we are loading 3 years data and want to show the 3 Columns in KPI .
(1) Current Period
(2) Previous period
(3) same period last year.
Do we have any mechanism to do the same thing in the Qlikview script ...so that no need to calculate in set analysis...
May be check out the As-Of Table: The As-Of Table
Another possibilty as the from Sunny suggested As-Of-Table could be to handle these periods like a fiscal year with an appropriate calendar. For this have a look here:
Fiscal Calendar with Non-Standard Days (Not 1-31)