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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
amayuresh
Creator III
Creator III

Subtotal in streight table


Hello,

I am having dataset like Category, commodity and Amount. Single category contains multiple commodities. I have created streight table showing top 10 Categories with sum(Amount), % of Total (% of each category Vs. Grand total of all categories). Also showing Dimension Subtotal (Grand total) and expression subtotal (Total) as showing in below image.

1.jpg

My question: Can I promot Total one step above and Demot Grand total one step below ?

5 Replies
Not applicable

Hi Mayuresh

can you post the qvw ?

Chris

amayuresh
Creator III
Creator III
Author

I will do it

amayuresh
Creator III
Creator III
Author

Please find qvd and qvw files for above questions.

Not applicable

Sorry Mayuresh

I tried some tips but unable to find a solution

Let me know when you get it

Best regards

Chris

Not applicable

HI,

It is not the solution you wanted but it mimics the format you wanted...

Sean