topic Re: Pivot Table in QlikView

Pivot Table

Tue, 27 Oct 2015 22:07:04 GMT

I Have a pivot table with some calculated columns.

If I set a total, then also the calculated columns will be totalized. Because some of the columns are percentages I don't want to totalize these columns.

How can I fix this?

Re: Pivot Table

Wed, 28 Oct 2015 16:03:14 GMT

Hi,

Not sure if this is over-simplifying the problem but does selecting No Totals in the Total Mode area work?

Regards,

Jason.

Re: Pivot Table

Thu, 29 Oct 2015 19:45:57 GMT

Hi, Thx for helping me.

No I can't select that switch.

Re: Pivot Table

pkelly — Thu, 29 Oct 2015 20:50:57 GMT

‌try the following

if(dimensionality() <> 0, your expression)