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.
What you have provided is the expression or is this a dimension? I am confused, can you elaborate?
It's a Calculated Dimension
U will be having direct option to achieve that.
Just click on the dimension-> Limitation-> fixed number and enter 5 in the box
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.
Have you tried using the limitation function on the properties panel?
Yes, I did now and I got it.
Retrieving data ...