topic pivot table question in QlikView

pivot table question

Wed, 05 Oct 2011 11:14:20 GMT

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.

its_anandrjs — Wed, 05 Oct 2011 12:30:03 GMT

Hi,

Do a expression like below for the new column

Count( if ( p=3, t ) )

Count( total m )

Rgds

Anand

Wed, 05 Oct 2011 14:57:06 GMT

thanks a lot.

its_anandrjs — Wed, 05 Oct 2011 18:39:47 GMT

Hi,

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

Rgds

Anand

Wed, 05 Oct 2011 19:15:49 GMT

one more Q

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