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: 
Anonymous
Not applicable

Top 5 fruits selection not working in Pivot and Line chart

hi all,

Top 5 fruits selection not working in Pivot and Line chart. please find the attached samples.

TIA

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

Hi,

You can achieve in many ways,

1)  Calculated dimension

=aggr(only({<Fruits={'=rank(sum(Sales))<=5'}>} Fruits),Fruits)

or

=aggr(if(rank(sum(Sales))<=5,Fruits),Fruits)


2) Calculated measure using set analysis

SUM({<Fruits = {"=Rank(SUM(Sales),4)<=5"}>}Sales)

or  using aggr function

if(Aggr(Rank(Sum(Sales)),Fruits,Month)<=5,sum(Sales))

3) Using Dimension Limit (straight table)

Dimension Limits tab --> Fruits dimension, Select Show only Largest 5 Values

4) back end script method

Capture.JPG

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

What is your expected output should be ?

Anonymous
Not applicable
Author

only top 5 sales should be visible in both the charts

devarasu07
Master II
Master II

Hi,

You can achieve in many ways,

1)  Calculated dimension

=aggr(only({<Fruits={'=rank(sum(Sales))<=5'}>} Fruits),Fruits)

or

=aggr(if(rank(sum(Sales))<=5,Fruits),Fruits)


2) Calculated measure using set analysis

SUM({<Fruits = {"=Rank(SUM(Sales),4)<=5"}>}Sales)

or  using aggr function

if(Aggr(Rank(Sum(Sales)),Fruits,Month)<=5,sum(Sales))

3) Using Dimension Limit (straight table)

Dimension Limits tab --> Fruits dimension, Select Show only Largest 5 Values

4) back end script method

Capture.JPG