Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva0606
Contributor III
Contributor III

Top Analysis with multiple dimension in Pivot table

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

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

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),

View solution in original post

2 Replies
zhadrakas
Specialist II
Specialist II

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),

sunny_talwar

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