Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

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)

Tags (1)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

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

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)

2 Replies
OmarBenSalem
Esteemed Contributor

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

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
Esteemed Contributor

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

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)

Community Browser