topic Re: Line chart - Custom Legend order in QlikView

Line chart - Custom Legend order

Thu, 14 Aug 2014 10:57:26 GMT

Hello,

I have a line chart where the legend is in an order which I would want to change.

If you notice though Stream 2 (orange line) is on the top whereas Stream 1 (blue) is way below.

I want to sort the legend based on the order in which the chart appears

So my legend would be

Stream 2

Stream 3

Stream 6

Stream 5

Stream 4

Stream 1

How do I achieve this ?

Thanks,

Re: Line chart - Custom Legend order

SunilChauhan — Thu, 14 Aug 2014 11:12:40 GMT

i thing its depends upon value you have in data. so its not passiable

the values range from 0-300 in case and blue value is near by zero.

thats why looking as above

hope this helps

Re: Line chart - Custom Legend order

Gysbert_Wassenaar — Thu, 14 Aug 2014 11:15:04 GMT

Edit the group you defined. On the Group Settings window click on the Sort Orders button. Then select the dimension of the group you want to sort. Choose to sort by Expression. Use an expression like: =match(only({1} MyStreamDimension), 'Stream 2','Stream 3','Stream 6','Stream 5','Stream 4','Stream 1'). Replace MyStreamDimension with the name of the dimension you want to sort.

Re: Line chart - Custom Legend order

giakoum — Thu, 14 Aug 2014 11:21:42 GMT

An interesting way from the QV Cookbook by Stephen Redmond. I definitely recommend you to buy it :

Re: Line chart - Custom Legend order

Thu, 14 Aug 2014 11:34:40 GMT

you can sort your values which show first but line positioning can not be changed,because it is defined by values,

you can sort your line by giving the expression.

Re: Line chart - Custom Legend order

Thu, 14 Aug 2014 12:49:44 GMT

Hello Gysbert,

Can you explain how this will work - my stream dimension will grow and is not only limited to the 6 streams.

Also, how will this help to order the legend in terms of value - today maybe stream 2 is on the top - but tomorrow it might be stream 6.

TIA

Re: Line chart - Custom Legend order

Thu, 14 Aug 2014 12:52:39 GMT

Hello Ioannis,

I use this when I have only one dimension, in this case its a cyclic group and when I use

Dual(If([Month Year]=Max(total[Month Year]),(cyc_ProStr) ,' '),my expression)) where cyc_ProStr is the name of my cyclic group - It doesn't work

Re: Line chart - Custom Legend order

Thu, 14 Aug 2014 13:15:53 GMT

Bhawna - sorting on the expression worked thanks !

Re: Line chart - Custom Legend order

Thu, 09 Oct 2014 14:37:18 GMT

Hello,

I'm also trying to figure out how to customize the order of my legend as I don't want it to automatically sort in asc or desc order.

I'm trying to understand how the expression works. I found the documentation in help file for the "match" function but I don't understand what the "only({1} MyStreamDimension)" part of your expression does. Is "only" a function? I couldn't find it in the documentation.

Could you please elaborate?

Thanks.

Re: Line chart - Custom Legend order

Gysbert_Wassenaar — Thu, 09 Oct 2014 16:24:55 GMT

Read this blog post for more information of the only() function: The Only Function

Re: Line chart - Custom Legend order

Fri, 10 Oct 2014 12:53:20 GMT

Thanks Gysbert. That's a very interesting function. Wonder why it's not in the search result of functions in help system.

Re: Line chart - Custom Legend order

Gysbert_Wassenaar — Fri, 10 Oct 2014 12:54:57 GMT

No idea. If I search the help file I can find it just fine.

Re: Line chart - Custom Legend order

Fri, 10 Oct 2014 13:06:02 GMT

Must be user error on my part then.

Thanks

Re: Line chart - Custom Legend order

Fri, 10 Oct 2014 13:08:47 GMT

For this,

If you want static change in your legend then you can change order in expression so accordingly that will change order in chart and make color for line.

But for dynamic need to think.