Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. 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!