topic Re: Pivot table error in QlikView

Pivot table error

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am getting an error adding calculated dimension to my pivot table. The expression is =count(student_number)

It is not a problem do display this expression in a text object =count(student_number) = 667

My intention is to see the sum on 453+200+14

Thanks for your help,

Larisa

Re: Pivot table error

swuehl — Wed, 16 Mar 2016 20:55:02 GMT

I think you don't need to create a calculated dimension here, but enable partial sums for your current dimensions on presentation tab. This will get you the totals.

The reason why the calculated dimension does not work: You need to use advanced aggregation aggr() if you want to use aggregation functions in the calc. dimension. But as I said, I believe that's not the way to got here.

Stefan

Re: Pivot table error

amayuresh — Thu, 17 Mar 2016 11:54:44 GMT

You can Select the Dimension in Presentation tab and Check Show Partial Sums. You get the total.

Re: Pivot table error

tyagishaila — Thu, 17 Mar 2016 12:11:59 GMT

To achieve your result. No need to create calculated dimension.

just click Show Partial Sums in Presentation Tab.

Cheers,

Re: Pivot table error

Thu, 17 Mar 2016 12:58:35 GMT

thanks a bunch

Re: Pivot table error

Thu, 17 Mar 2016 12:59:22 GMT

thank you!

Re: Pivot table error

Thu, 17 Mar 2016 13:01:55 GMT

Thank you!