Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Pasan
Contributor
Contributor

Pivot Table subtract one column with another

Level Permanent Permanent Contract Contract
  Base Total Rate Base Total Rate
L1 10 20 15 25
L2 12 24 14 28

 

Pasan_0-1716793252342.png

Hi All, In the above pivot table I would like to subtract Total rate of permanent by total rate of contract for each level. So the answer for L1 should be 20-25=-5. How can I do that in Qliksense pivot table?

 

Labels (1)
2 Replies
Chanty4u
MVP
MVP

Try this 

Sum({<Type={'Permanent'}>} [TotalRate]) - Sum({<Type={'Contract'}>} [TotalRate])

 

Pasan
Contributor
Contributor
Author

Nope, this does not work for some reason. Thank you!