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

Bar chart, choose top 10 product name but eliminate the empty name

Hi,

Here is the graph showing the bar chart I want to create.

There are more than 10,000 product name'ProductName', I want to only show top 10 or 15 in the graph in terms of ''Sum(NumberUniteSold)''

at same time eliminate the one with 'ProductName'

How could i do that?

Thank you.

was using follow function in the DATA --> Measure place:

=Aggr(If(Rank(Sum(NumberUniteSold),4)<=10,ProductName,ProductName)

1 Solution

Accepted Solutions
OmarBenSalem

if you want juste to eliminate the empty name:

choose the same dimension and uncheck this:

Capture.PNG

just use your simple measure : sum(NumberUniteSold)

View solution in original post

2 Replies
OmarBenSalem

Your have a dimension: called "Product Name" that has a value = "Product Name" that you want to eliminate?

If this is the case:

As a dimension: choose product Name and limit it to the first 10/15 :

Capture.PNG

as a measure:

sum({<ProductName -={'Product Name'}>}NumberUniteSold)

OmarBenSalem

if you want juste to eliminate the empty name:

choose the same dimension and uncheck this:

Capture.PNG

just use your simple measure : sum(NumberUniteSold)