Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to calculate subtotal ?

Hello everyone,

I currently have a pivot table looking like this :

City            Product          quantity

Paris              A                     2

Paris              B                     1

London          C                     3

London          B                     4

City and Product are dimmensions whereas quantity is an expression  (sum(count_s)).

I would like to get subtotal for the city, something like this :

City            Product          quantity

Paris              A                     2

Paris              B                     1

Paris          Total                   3

London          C                     3

London          B                     4

London       Total                  7

Thank you for help

Have a good day !

Laura

1 Solution

Accepted Solutions
marcarreras
Valued Contributor

Re: How to calculate subtotal ?

go to presentation tab, choose your dimension and check "show partial sums".

Marc.

4 Replies
marcarreras
Valued Contributor

Re: How to calculate subtotal ?

go to presentation tab, choose your dimension and check "show partial sums".

Marc.

venkatasreekant
Valued Contributor

Re: How to calculate subtotal ?

Hi,

In the  presentation tab, Select your dimension and check "show partial sums" Option ..


renjithpl
Valued Contributor

Re: How to calculate subtotal ?

Have you tried

Under the Presentation tab select City dimension check the "Show Partial Sums" ?


Not applicable

Re: How to calculate subtotal ?

thank you ! I had tried it but instead of selecting "Product", I was tryin with city...

Community Browser