Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Subtotal in pivot table

Hi, a get this pivote chart:

1.jpg

I want to know how i get a subtotals for each Operador, like this:

2.jpg

Items 1,2,3 are calculated with an Count(Date). Is the only one field through which I can count.

Thanks for you help!

1 Solution

Accepted Solutions
montero91
Contributor

Re: Subtotal in pivot table

Hi German

Try with:

= sum (Total <Operator> Value)

        
   for the subtotals use <> after Total.

for percentages


=sum (Value) / sum (Total <Operator> Value)       


  whit format %

I hope to help you

2 Replies
montero91
Contributor

Re: Subtotal in pivot table

Hi German

Try with:

= sum (Total <Operator> Value)

        
   for the subtotals use <> after Total.

for percentages


=sum (Value) / sum (Total <Operator> Value)       


  whit format %

I hope to help you

Not applicable

Re: Subtotal in pivot table

Thanks Manuel ! Muchas gracias.

Community Browser