Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.