Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten
Creator II
Creator II

Year on year comparison pivot table

I would like to make a year on year comparison in a pivottable. So I would like to calculate  Amount1 2019- Amount3 2020, Amount2 2019- Amount4 2020 and create an additional column which displays the result of the difference, 

Kirsten_2-1610558152455.png

 

Data looks like this

WS       Market    Year          Total Cost    

FCO      NAM         2019        Amount1 

 

I tried several options from the examples in the forum but they all returned a value 0 in the column, which is not correct

 

1 Reply
Prashant_N
Contributor III
Contributor III

Hi,

I am not very clear with the requirement.

Can you give us dummy data and required output so we can work on.

Regards,

Prashant