Rank in Bar Chart

[#1]

Good Day,

   How to put a Rank in Bar Chart?

Like 1st, 2nd 3rd so on?

Kindly see the picture.

Thank you.

[fdelacal]

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

HOPE IT HELPS

[#3]

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]

sort tab- descending

regards

vaibhav

[fdelacal]

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]

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.

[#7]

Good Day,

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

     Regards,

     raem

[Anonymous]

Plz find the attached

hope this help

[Anonymous]

Plz find the attached

hope this help

[whiteline]

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?