To show top 5 values

[MK9885]

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.

[sunny_talwar]

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

[MK9885]

It's a Calculated Dimension

[prashanth1712 · Accepted solution]

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

[Anonymous]

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

[MK9885]

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.

[MK9885]

Yes, I did now and I got it.

Thanks.