Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Mitch_Data
Contributor III
Contributor III

Showing top 10 Set Analysis

Hi Guys,

 

I have a set analysis with two conditions: One it has to be grouped by "Group Bracket" = Order

Second condition - show the top 10 brand corresponding to the different brackets. 

 

Calculationnr is a distinct value so I want to count how many times it occurs by group bracket (top 10).

Do you have any idea what I can do to show the top 10, because now it shows me the top 20 +.

Formula I want to adapt.

Count({<[Group Bracket]-={"*Order*"}>+<[Brand] -= {"=Rank(Count([Calculationnr])) <=10"}>} Brand)

1 Solution

Accepted Solutions
Mitch_Data
Contributor III
Contributor III
Author

Never mind Count({<[Group Bracket]-={"*Order*"}>+<[Brand] -= {"=Rank(Count([Calculationnr])) <=10"}>} Brand) 

Is the right formula, I did something wrong in my comparison.

View solution in original post

1 Reply
Mitch_Data
Contributor III
Contributor III
Author

Never mind Count({<[Group Bracket]-={"*Order*"}>+<[Brand] -= {"=Rank(Count([Calculationnr])) <=10"}>} Brand) 

Is the right formula, I did something wrong in my comparison.