Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Display data for a Supplier with a Particular Rank


I am relatively new to Qlik Sense/coding and struggling with the following (refer to attached document for screen shots and more information)

In brief:

I have a table which lists the 5 worst performing suppliers from a  non-conformance perspective.

In the same sheet I am attempting to generate 5 bar charts, one for each Supplier (showing 12 months of data).

How do I create a chart, each of which containing data for a specific Rank.

The expression below lists the supplier name of a particular rank but I am unable to apply this to a bar chart (refer to attachment).

  •  =FirstSortedValue ([List name],-aggr(Count([Notification]),[List name]),3)

Thanks in Advance


Labels (1)
3 Replies
Partner - Creator III
Partner - Creator III

Hi Ben,

I would try to use the following expression for dimension:

If( [List name]=FirstSortedValue ([List name],-aggr(Count([Notification]),[List name]),3), Supplier, Null())

Also, you can create a variable with parameter:

dim_Supplier = If( [List name]=FirstSortedValue ([List name],-aggr(Count([Notification]),[List name]),$1), Supplier, Null())

So, all your dimensions will be like this:


Just check the syntax.

Good Luck!

Contributor III
Contributor III

Thank you for the prompt reply. Unfortunately it was unsuccessful. The expression showed as 'OK' but the chart stated "Error All expressions are disabled"

FYI, in your expression you refered to Supplier. I replaced it with [Listname] (which is the supplier name). 

=If([List name]=FirstSortedValue ([List name], -aggr(Count([Notification]),[List name]),1),[List name],Null())

Any help would be appreciated.

Partner - Creator III
Partner - Creator III

Hi Ben,

First, I want to make sure expression is used as a dimension, not as a regular chart expression.

Second, does your chart show the data if you just hard code dimension value: If( [List name]='Bla-Bla', [List name], Null())?

At last, can you upload your app?