topic Re: Pivot Table Total in QlikView

Pivot Table Total

techvarun — Wed, 17 Jul 2013 12:07:21 GMT

I have a pivot table as attached image. in that pivot table i need to show the sum of mark1,mark2,mark3,mark4,mark5

Both rowwise and columnwise

Thanks in advance

Regards

kaushiknsolanki — Wed, 17 Jul 2013 12:09:04 GMT

Hi,

Go to Properties -> Presentation -> Click on the dimension and check Partial sum

Regards,

Kaushik Solanki

techvarun — Wed, 17 Jul 2013 12:55:32 GMT

am able to get totals on expression column but not in mark1 ,mark2,....... column

Regards

kaushiknsolanki — Wed, 17 Jul 2013 13:00:13 GMT

Hi,

Do you have the seperate expression for each mark?

Regards,

Kaushik Solanki

techvarun — Wed, 17 Jul 2013 13:02:01 GMT

No Kaushik Solanki all the marks columns are directly from table

techvarun — Wed, 17 Jul 2013 13:08:32 GMT

Thanks you

I have changed all the Dimentions to expressions and now it is working fine

Thanks & Regards