# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## pivot table question

Hello all,

I’ve been created the following pivot table and I’m knocking my head who to add a new column that will show me the relative value from the total.

below you can see the table that I created.

for example:

I like to take count(if(p=3,t)) / total count(m)  - --- (both marked in red)

Thanks for your help.

1 Solution

Accepted Solutions
MVP

## pivot table question

Hi,

Do a expression like below for the new column

Count( if ( p=3, t ) )

/

Count( total m )

Rgds

Anand

4 Replies
MVP

## pivot table question

Hi,

Do a expression like below for the new column

Count( if ( p=3, t ) )

/

Count( total m )

Rgds

Anand

Not applicable

thanks a lot.

MVP

## pivot table question

Hi,

Hope you got correct or helpful answer from this if so mark it Correct or Helpful so other can see it.

Rgds

Anand

Not applicable

## Re: pivot table question

one more Q

how i calculate the difference between the bold columns in new column ?

 date S.regionname hour category sum® 2011-10-04 A 19 1 170,930 2011-10-04 A 19 2 17,673 2011-10-04 A 19 3 2,193 2011-10-04 A 19 4 3,051 2011-10-04 A 19 5 2,607 2011-10-04 A 19 6 40,812 2011-10-04 A 19 Total 237,266 2011-10-03 A 19 1 192,166 2011-10-03 A 19 2 28,836 2011-10-03 a 19 3 3,114 2011-10-03 a 19 4 2,928 2011-10-03 a 19 5 2,496 2011-10-03 A 19 6 5,625 2011-10-03 A 19 Total 235,165 Total 472,431
Community Browser