How to calculate YoY change in pivot table for multiple dimensions in Qlik Sense

[SRK121]

Hello Everyone,

I am trying to calculate Year on year change for multiple dimensions in pivot table. I have data (number of claims) since year 2000 until today for multiple dimensions. I tried above & below functions which works only for current & previous year in set analysis but not successful for complete pivot table.

Is there any way or possible best output to show records in pivot table with dynamic filter selection (Financial year or Calendar year).

I have multiple dimensions like - Financial Year, Calendar Year, Claims, Claims Type, Division etc. 

(Note: Also, Claims, Claims type, division are part of multi dimensions created through island.)

I have only 2 Claims (1&2) and multiple claims type and so on. I have selected only Claim 1 from filter and selected calendar year. I have not done any further selection on calendar year  like 2000, 2005 etc.

Below is the sample output I am looking for:

Basically ( no. of claims in year 2001 - no. of claims in 2000)  output in column yoy change 2001 and so on in pivot table and same for claims type A, B, C in respective columns.

I am not sure even if it possible in pivot table in Qlik Sense or any suggestions would be good to show the best outcome for this requirement.

Thankyou for your help & assistance. 

[brunobertels · Accepted solution]

Hi 

Try this 

let say your mesure is sum(claims) 

the formula is 

sum(claims) - before(sum(claims)) 

in  % 

(sum(claims) - before(sum(claims)) ) / sum(claims) 

Or with set analysis 

Sum({<[Financial Year]= {'$(=Max([Financial Year]))'}>} claims)

-

Sum({<[Financial Year]= {'$(=Max([Financial Year])-1)'}>} claims)

[SRK121]

Hi Brunobertels,

Thankyou for your help.

sum(claims) - before(sum(claims)) 

in  % 

(sum(claims) - before(sum(claims)) ) / sum(claims) 

This worked for me. 🙂