topic Re: Period over period calculation in QlikView

Period over period calculation

singhcv123 — Wed, 15 Jun 2016 11:05:41 GMT

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

Re: Period over period calculation

sunny_talwar — Wed, 15 Jun 2016 11:17:32 GMT

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

Re: Period over period calculation

marcus_sommer — Wed, 15 Jun 2016 11:20:49 GMT

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