Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Subtotals in a Pivot table

Hi,

I am unable to figure out a subtotal formula for the below structured pivot table

Dim 1          Dim 2              Metric 1                Metric  2                    expression/Metric 3

Q1               NA                    10                              20                     Metric 2/Subtotal of Metric 2   = 20/50 = 40%      

Q1               1-100               10                              30                       30/50 = 60%

Subtotal--------------------------  10+10                     20+30

Q2               1-100                 20                              20    

I am unable to calculate the expression 3/metric 3 in the pivot table.........please let me know

Please find the attached excel to see what problem I am facing

Thanks,

Harsha            

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Subtotals in a Pivot table

A solution is attached.

2 Replies
nagaiank
Valued Contributor III

Re: Subtotals in a Pivot table

A solution is attached.

paulomulato
Contributor

Re: Subtotals in a Pivot table

Good morning, could put the solution in the message body , I am using the free edition, thanks.

Community Browser