topic Re: Rank in Bar Chart in QlikView

Rank in Bar Chart

Tue, 30 Oct 2012 07:58:15 GMT

Good Day,

How to put a Rank in Bar Chart?

Like 1st, 2nd 3rd so on?

Kindly see the picture.

Thank you.

Re: Rank in Bar Chart

fdelacal — Tue, 30 Oct 2012 08:29:33 GMT

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

HOPE IT HELPS

Re: Rank in Bar Chart

Tue, 30 Oct 2012 08:34:13 GMT

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

Re: Rank in Bar Chart

Anonymous — Tue, 30 Oct 2012 08:48:01 GMT

sort tab- descending

regards

vaibhav

Re: Rank in Bar Chart

fdelacal — Tue, 30 Oct 2012 08:48:31 GMT

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

Re: Rank in Bar Chart

whiteline — Tue, 30 Oct 2012 08:57:00 GMT

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.

Re: Rank in Bar Chart

Tue, 30 Oct 2012 09:36:43 GMT

Good Day,

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

Regards,

raem

Re: Rank in Bar Chart

Anonymous — Tue, 30 Oct 2012 13:35:18 GMT

Plz find the attached

hope this help

Re: Rank in Bar Chart

Anonymous — Tue, 30 Oct 2012 13:36:36 GMT

Plz find the attached

hope this help

Re: Rank in Bar Chart

whiteline — Sat, 03 Nov 2012 09:44:40 GMT

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?

Re: Rank in Bar Chart

whiteline — Sat, 03 Nov 2012 09:46:45 GMT

Hi.

You don't have to create a separate invisible expression for text labels.

Just use the right expression for numeric part: =dual('Rank ' & Rank(Sum(Value)), Sum(Value))