Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Substraction

Please find the attached .QVW file.

Query1:-

  I want to remove extra space from Market Value and Demo Value (Pivot Tables) , how can I remove that ?

  Query2:-

  I want to subtract Market Value (300) from Demo Value(1700) i.e. 1700-300=1400 and should display this subtraction below Total as

Net Assets** ("Demo Value-Market Value")=1400

Please help.

10 Replies
Not applicable
Author

Thanks Anil for your help , It solved my problem.