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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
hamza99a
Creator II
Creator II

Total groupings

Hello Qlik Community,

Essentially I have a vizlib table in which I show branch region and account types. What I am trying to show as well is a total of each branch region. So i would like to keep the current 9 rows and add 3 additional rows called Central Total, Other Total, and South Total. I tried using the show totals button in the table, however it does not give me what I need. I believe it has something to do with grouping maybe in the data load script. Any help would be appreciated.

Thanks! stalwar1youssefbelloumjohnw

1 Reply
MK9885
Master II
Master II

You might be looking for a PnL chart

It can be driven by an eternal XL file

How to Create a Profit and Loss Statement in QlikView

Or search for PnL extensions in Qlik if your data is not too complex.