Show partial totals in Qlik Sense - Qlik Community

PrashantRupani · ‎2021-01-11

Hi,

I would like to show the partial total of products and grand total. Is it possible in Qlik Sense? I am using a straight table.

Sales Manager , Sales Person ID, # of Orders

Joe, 101, 5

Joe, 102, 10

Total for Joe : 15

John, 103, 20

John, 104, 30

Total for Joe L 50

Grand Total : 65

chrismarlow · ‎2021-01-11

Hi,

There is a work around suggested here;

Note this does put the total in a separate column, rather than row.

The only other thing I can think of would be something using a valuelist/calculated dimension, but not sure if anyone else has a better suggestion.

Cheers,

Chris.