Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day,
How to put a Rank in Bar Chart?
Like 1st, 2nd 3rd so on?
Kindly see the picture.
Thank you.
CHART PROPIERTIES -- DIMENSION LIMITS.. (SHOW ONLY) YOU CHOOSE AND UNCHECK SHOW OTHER.
HOPE IT HELPS
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
sort tab- descending
regards
vaibhav
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
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.
Good Day,
Thank you for your response, All the bars get Rank 1.
Regards,
raem
Plz find the attached
hope this help
Plz find the attached
hope this help
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?