Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mohammedsleem
New Contributor

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

Re: show the subtraction column in pivot table

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

see the attached

2 Replies

Re: show the subtraction column in pivot table

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

see the attached

mohammedsleem
New Contributor

Re: show the subtraction column in pivot table

Thanks a lot. This is working fine.

Community Browser