Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammedsleem
Partner - Contributor III
Partner - Contributor III

show the subtraction column in pivot table

Hi,

in the attached QVW sample, I have a table which looks as shown in the below image.

Sun table.png

I want to show a pivot table in my dashboard that shows the count of records per each type and year (the current year and the previous year only) then show a column display the subtraction between the two years summing results for each type. The pivot table should looks like that:

Sun table - should be.png

any idea how I can do that.

1 Solution

Accepted Solutions
Kushal_Chawda

if its is always current Vs Prev then you can do something like this

see the attached

View solution in original post

2 Replies
Kushal_Chawda

if its is always current Vs Prev then you can do something like this

see the attached

mohammedsleem
Partner - Contributor III
Partner - Contributor III
Author

Thanks a lot. This is working fine.