Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arvind654
Honored Contributor II

To show top 5 values

I'm trying to show only top 5 values in a bar graph in Qlik Sense. I'm aware of Rank function but not able to achieve it.

I've this as dimension, =If([Field1] = 'Value' and Field2 <> 'Value, Field2)

I want to show top 5 based on the above expression.

Tags (1)
1 Solution

Accepted Solutions
prashanth1712
New Contributor III

Re: To show top 5 values

Hi arvind,

U will be having direct option to achieve that.

Just click on the dimension-> Limitation-> fixed number and enter 5 in the box

bar chart.png

6 Replies
MVP
MVP

Re: To show top 5 values

What you have provided is the expression or is this a dimension? I am confused, can you elaborate?

arvind654
Honored Contributor II

Re: To show top 5 values

It's a Calculated Dimension

prashanth1712
New Contributor III

Re: To show top 5 values

Hi arvind,

U will be having direct option to achieve that.

Just click on the dimension-> Limitation-> fixed number and enter 5 in the box

bar chart.png

okolyug16
Contributor II

Re: To show top 5 values

Have you tried using the limitation function on the properties panel?

arvind654
Honored Contributor II

Re: To show top 5 values

Thanks Prashanth,

I was actually using an extension for Bar Graph and that is why I couldn't see the sorting option. Now I used the default Qlik Sense chart and I got it as you showed.

arvind654
Honored Contributor II

Re: To show top 5 values

Yes, I did now and I got it.

Thanks.