Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
yangcelinexu
Creator
Creator

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
Partner
Partner

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
Partner
Partner

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
Partner
Partner

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