Discussion board where members can get started with QlikView.
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.
I like to take count(if(p=3,t)) / total count(m) - --- (both marked in red)
Thanks for your help.
Go to Solution.
Do a expression like below for the new column
Count( if ( p=3, t ) )
Count( total m )
thanks a lot.
Hope you got correct or helpful answer from this if so mark it Correct or Helpful so other can see it.
one more Q
how i calculate the difference between the bold columns in new column ?