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: 
Anonymous
Not applicable

Need to add total, percentage , avg in same table like below. Up to total I achieved it .

table-structure.PNG

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You're out of luck. A straight table chart or a pivot table can have only one total line, not three. Qlikview is not a spreadsheet, so it can't do this kind of thing.

But you can try using the dimensionality() function in your expressions to calculate the totals in a different way. See this example: https://community.qlik.com/t5/New-to-QlikView/Table-with-2-lines-just-on-total-Dimensionality-0/td-p...


talk is cheap, supply exceeds demand