Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

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

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

pivot table question

thanks a lot.

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 ?

dateS.regionnamehourcategorysum®
2011-10-04A191170,930
2011-10-04A19217,673
2011-10-04A1932,193
2011-10-04A1943,051
2011-10-04A1952,607
2011-10-04A19640,812
2011-10-04A19Total237,266
2011-10-03A191192,166
2011-10-03A19228,836
2011-10-03a1933,114
2011-10-03a1942,928
2011-10-03a1952,496
2011-10-03A1965,625
2011-10-03A19Total235,165
Total


472,431