topic Re: Bar Chart 2 Dimentions sorting in QlikView

Bar Chart 2 Dimentions sorting

orital81 — Wed, 19 Dec 2012 10:25:29 GMT

Hi all

I would like to sort a bar chart by period and by customer.

Meaning that small customers will be on top of the big every period.

For example : in the screenshot below, Customer B (Yellow) will be below A in 2008

qvw file attached.

Thanks for your help

Ori

Re: Bar Chart 2 Dimentions sorting

sujeetsingh — Wed, 19 Dec 2012 11:36:40 GMT

Hi,

i diged much but finally giving you a thread with similar issue may it help you..

http://community.qlik.com/message/244397#244397

http://community.qlik.com/message/53978#53978

Re: Bar Chart 2 Dimentions sorting

orital81 — Wed, 19 Dec 2012 12:18:01 GMT

Hi Son Of Sardar, the 2nd link is more relevant but still doesn't promote me to the result.

Thanks anyway

Re: Bar Chart 2 Dimentions sorting

Gysbert_Wassenaar — Wed, 19 Dec 2012 19:33:27 GMT

With some messing about it can be done. See attached qvw.

Re: Bar Chart 2 Dimentions sorting

rwunderlich — Wed, 19 Dec 2012 20:22:15 GMT

Nice solution Gysbert!

I think you can simplify the color expressions to:

=color(FieldIndex('customer', customer))

If you use a dual() for the calculated dim you can get the Customer name in the pop-up

=aggr( dual( only(customer) , sum(amount) ) ,year,customer)

Ideally, that would work as the legend also and then the seperate legend chart wouldn't be required. But the legend groups by the numeric value -- I couldn't get it to display just the string customer values.

See attached.

-Rob

Re: Bar Chart 2 Dimentions sorting

orital81 — Wed, 19 Dec 2012 20:44:16 GMT

Thanks for the quick and accurate answer!

Re: Bar Chart 2 Dimentions sorting

Gysbert_Wassenaar — Thu, 20 Dec 2012 08:46:16 GMT

Actually, I later realized I already had added a color field to the table to link the customers with a color. So I could just have used color([color]) instead.

Thanks for the suggestion about using the dual function. That's a new trick for me with regards to making the popup look nice.

Re: Bar Chart 2 Dimentions sorting

rwunderlich — Thu, 20 Dec 2012 16:54:59 GMT

My point on color() was that there was no need for a color field. You can use the naturally occuring FieldIndex() to derive the same value.

-Rob

Re: Bar Chart 2 Dimentions sorting

Gysbert_Wassenaar — Thu, 20 Dec 2012 17:08:09 GMT

Ahaa, I get it now. Cool. Thanks for educating me some more.