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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser2021
Contributor III
Contributor III

Qlik Sense SaaS Pivot Table

I have a Qlik Sense SaaS pivot table that has Payments and Balance as measures displayed by each month.    Is there a way to display only the Total column for “Balance” and not the monthly  “Balance” column? 

Instead of the below...

Customer Group Totals 14-Jan 14-Feb
  Payments Balance Payments Balance Payments Balance
retail 3250 2500 1000 2000 250 500
             
             

 

I want it to  look like the below...

Customer Group Totals 14-Jan 14-Feb
  Payments Balance Payments Payments
retail 1250 2500 1000 250
Labels (2)
2 Replies
Patricia_Silva
Specialist II
Specialist II

Hello @qlikuser2021, could you please share a screenshot of the pivot table? Thanks a lot!

Help users find answers! Don't forget to mark a correct resolution 🙂
qlikuser2021
Contributor III
Contributor III
Author

qlikuser2021_0-1643927431309.png

 

Collections are monthly where facevalue and purchase price are static and only would have values for the month of purchase.  I don't want facevalue and purchaseprice to be displayed for each month.  I just want them in one column on the left next to the total of the monthly collections.