Rank and Sort Within a Chart

[hammermill21]

Hello,

I have a bar chart that I am ranking the top standards, which is working but I want to only show the top 3 that I have ranked. How could I do that?

I currently have under measures:

To sun all the standards:

=SUM(Den)-SUM(Num) 

Then to Rank the standards based on those sums above:

Rank(SUM(Den)-SUM(Num))

Thank you!

[Wlad_Masi]

Qlik Sense has a limitation field in the dimension where you can select the option "Fixed Number" and Top 3, as you can see in the image below.

Let me know if it is what you are looking for.

[nazaQ · Accepted solution]

Hi,

you can use limitation functionality in the dimension of the chart.

[hammermill21]

HI,

Yes, that does work! I just needed to unclick the "Show Others" and it is showing me the correct information.

Thank you!

[Wlad_Masi]

You are welcome!
Glad to help you.