Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor 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
Highlighted
Honored Contributor II

Re: Total groupings

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.