Discussion Board for collaboration related to QlikView App Development.
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
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.
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
Would you be able to share a sample to look at the issue?