topic Re: Top Analysis with multiple dimension in Pivot table in QlikView

Top Analysis with multiple dimension in Pivot table

siva0606 — Thu, 21 Dec 2017 11:30:00 GMT

Hi Everyone ,

Good Morning. I am creating a Pivot Table with the help of below calculated dimensions.

=if(vSlider = 0,Product,if(Aggr(Rank(TOTAL Sum( Sales ) ), Product) <=vSlider,Product))

=if(vSlider = 0,Group,if(Aggr(Rank(TOTAL Sum( Sales ) ), Group) <= vSlider,Group))

And I am using the below expression

Sum({<Year={2017},Product=,Group=>}Sales)

I am using slider to get the top values from 5 to 30 separated by 5.

When i use a single dimension, the pivot table and Top analysis works fine and similarly when i use more than one dimension it doesn't works.

For Example , If i use only Product as a first dimension then it works and if i expand the pivot table with the second dimension, the top analysis doesn't works.

Suppress when value is null is checked.

Kindly help me on the above scenario.

Best Regards,

Siva

Re: Top Analysis with multiple dimension in Pivot table

zhadrakas — Thu, 21 Dec 2017 12:11:40 GMT

try to add your Dimension in the aggr() function:

Aggr(Rank(TOTAL Sum( Sales ) ), Product, secondDimension)

i have not tested that. Eventually you Need build a condition

if(dimensionality()=1, aggr(..., Product),

if(dimensionality()=2, aggr(..., Product, SecondDimension),

Re: Top Analysis with multiple dimension in Pivot table

sunny_talwar — Thu, 21 Dec 2017 12:27:28 GMT

Would you be able to share a sample to look at the issue?