Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor II

Period over period calculation

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

2 Replies

Re: Period over period calculation

May be check out the As-Of Table: The As-Of Table

Re: Period over period calculation

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 Year

Fiscal Calendar with Non-Standard Days (Not 1-31)

- Marcus

Community Browser