Make a calculation which is dependent on pivot table columns

[satyax]

I need to create a column to the right that shows the change in historical values (both the difference and percentage change).

I have tried to prepare this in Excel and have provided a screenshot.

I have attached both the data and the Qlik Sense pivot table.

Data set

Qlik Sense Pivot table

Requirement

[marcus_sommer]

Don't use Year as horizontal dimension else apply 4 expressions with:

sum({< Year = {2024}>} Value)
sum({< Year = {2025}>} Value)
column(2) - column(1)
column(2) / column(1)

[satyax]

Apologies, I am a beginner in Qlik Sense.

Are you suggesting not to keep Year in Column dimension instead add 4 of the expressions in Row which you have mentioned?

I tried so but these expressions gives error.

[marcus_sommer]

Yes, no Year as dimension and 4 expressions as columns or as rows.

[satyax]

Please help, this gives error.

[marcus_sommer · Accepted solution]

You need to adjust it to your data-set. To make it simple at the start just pull the Name as dimension and the above shown expression - by replacing Value with the real field-name of A or B or C.