topic Re: Total in Pivot Table... in QlikView

Total in Pivot Table...

israrkhan — Sun, 28 Jun 2015 16:27:59 GMT

Hi Guys,

i have a pivot table with two dimensions and one expression.

see the sample image.

i have more than 50 brands, in a list box, let say i selected 4 brands, now the partial sum(Total) is for selected 4 brands only,

but i want to show the whole sum(Total) for all brands. or if i could show an other row as 'Others' then the partial sum can be correct.

but i dont know ,how to do it...The total row must be for all brands, does matter whatever is selected in brands...

Many Thanks..

Re: Total in Pivot Table...

sunny_talwar — Sun, 28 Jun 2015 16:48:01 GMT

Try this:

If(Dimensionality() = 0, Sum({1} Sales), Sum(Sales)) //Replace Sum(Sales with your expression, just add {1} to the true condition.

Attaching a sample with dummy data. Hope that helps.

Best,

Sunny

Re: Total in Pivot Table...

israrkhan — Sun, 28 Jun 2015 17:15:08 GMT

worked...

Many thanks..

little confuse about the expression, can you please elaborate a bit.

i think in my case, Dimensionality() will be 1 all the time?

and i have read that , the dimensionality start from 1 to upward.

when it can be zero?

many thanks...

Re: Total in Pivot Table...

sunny_talwar — Sun, 28 Jun 2015 17:35:16 GMT

Add an expression: Dimensionality() and SecondaryDimensionality() in your existing chart and you will know which sub-total has what Dimensionality() and SecondaryDimensionality(). This you can then refer in your main expression based on which combinations needs to do what. SecondaryDimensionality() is only used in a pivot table (but I thought I will explain its use as well)

I hope this will help. For more info on Dimensionality you can check the info by Robert_Mika‌: How to use - Dimensionality()

HTH

Best,

Sunny