Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.