topic Re: Pivot Table - Dynamic Total Column in QlikView

Pivot Table - Dynamic Total Column

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Is there any way, by which I can have total column in Pivot table based on some condition.

eg. If I am having dimension as MonthName as one of the dimension on which I have checked the partial sum check box. Then I want to get total of only selective columns, say Jan,Feb,Mar for that matter.

Thanks In Advance

Re: Pivot Table - Dynamic Total Column

Gysbert_Wassenaar — Fri, 18 Mar 2016 09:07:20 GMT

Yes, that's possible. You can use the dimensionality() function to check which level you're at and use this to calculate different expressions: if(dimensionality()=0, sum({<Month={'Jan','Feb','Mar'}>}Amount), sum(Amount)). If your month dimension is displayed as columns you use the secondarydimensionality() function instead.

Re: Pivot Table - Dynamic Total Column

Kushal_Chawda — Fri, 18 Mar 2016 09:14:57 GMT

Yes. It's possible. Use Dimesionality() or secondarydimensionality() functions. see this below

Custom total calculation in Pivot table

Re: Pivot Table - Dynamic Total Column

Fri, 18 Mar 2016 09:25:27 GMT

Thanks a lot for your quick reply.

I am a bit confused regarding the functionality of dimensionality() or secondary dimensionality().

Will you please elaborate this, so that I will have a better understanding of the same.

Re: Pivot Table - Dynamic Total Column

Gysbert_Wassenaar — Fri, 18 Mar 2016 10:37:24 GMT

Dimensionality() is for dimensions shown as rows. SecondaryDimensionality() is for dimensions pivoted to columns.