Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

How to get sum of rows of pivot in a single value

I have pivot table like this

Centers Column1 Column2

A 2 2/6=0.33%

B 1 1/6=0.16%

C 3 3/6=0.5%

Sum of Column here is with rows values are

2+1+3=6

I want to divide this sum value with single cell value of Centers column in suppose Column2

how can i get it please tell this, i able to get the value of Column(1) but not the sum values of all rows

2 Replies
erich_shiino
Honored Contributor

How to get sum of rows of pivot in a single value

Let us say that the expression for column1 is

=sum(Value)

the expression for Column2 would be

=sum(Value)/sum(total Value)

How to get sum of rows of pivot in a single value

You may want to search the QV help for the topic "Sum of Rows in pivot tables"