Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank in Bar Chart

Good Day,

   How to put a Rank in Bar Chart?qview.jpg

Like 1st, 2nd 3rd so on?

Kindly see the picture.

Thank you.

10 Replies
fdelacal
Specialist
Specialist

CHART PROPIERTIES -- DIMENSION LIMITS.. (SHOW ONLY) YOU CHOOSE AND UNCHECK SHOW OTHER.

HOPE IT HELPS

Not applicable
Author

Good Day Sir,

     Thank you for your response.

     I need to show the rank of the highest value to smallest. is it possible?

Regards,

Raem

Anonymous
Not applicable
Author

sort tab- descending

regards

vaibhav

fdelacal
Specialist
Specialist

you can download the reference manual, there you can search for rank.. there are some options to do that you want.

if i will know that you want maybe i can resolve he problem.

here the link

http://community.qlik.com/docs/DOC-1794

in the search objet write rank,

Hope it help you

whiteline
Master II
Master II

Hi.

Suppose your expression for bars is =Sum(Value).

Then, use expression

=dual('Rank ' & Rank(Sum(Value)), Sum(Value))

Toggle checkbox 'Values on data points' for the expression.

Make sure that Number format setting is set to 'Expression default' for the expression.

Not applicable
Author

Good Day,

     Thank you for your response, All the bars get Rank 1.

     Regards,

     raem

Anonymous
Not applicable
Author

Plz find the attached

hope this help

Anonymous
Not applicable
Author

Plz find the attached

hope this help

whiteline
Master II
Master II

I think you've missed something, could you post your sample where all bars get 1 with =dual('Rank ' & Rank(Sum(Value)), Sum(Value)) expression?