Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.