topic Re: Customized sort in Legend in QlikView

Customized sort in Legend

Mon, 21 Jan 2013 10:44:12 GMT

Hi All,

In my Legend I want to show my product as first position and remaining product according to sorting order (A-z) and others should be last. Could you please help me how can we achieve it?

Thanks,

Rahul

Re: Customized sort in Legend

Anonymous — Mon, 21 Jan 2013 11:04:11 GMT

It's not possible to sort on the secondary dimension. See post: http://community.qlik.com/message/104396#104396. I think the sorting applies across the whole of the first expression, irrespective of the slicing by dimensions.

You may be able to force the sort order of the secondary dimension by adding in a 'dummy' first expression that doesn't have any display options ticked (i.e. not bar, line etc.). In this expression you could ask for a count of the product name. As this should return 1 for all the products they may be delievered in alphabetic order.

Jonathan

Re: Customized sort in Legend

Mon, 21 Jan 2013 11:11:53 GMT

Hi,

I have only dimension that is products. Is there is any way to do custon sort by editing expression?

Thanks

Re: Customized sort in Legend

Anonymous — Mon, 21 Jan 2013 11:17:42 GMT

You have only one dimension ? You don't mean the legend that appears in the top right corner of a chart ?

If so, then yes, on Sort properties tick Expression, set to only(Product). This shouldn't be necessary though as ticking Text should have done that for you. Maybe best to post a picture or an application.

Jonathan

Re: Customized sort in Legend

Anonymous — Mon, 21 Jan 2013 11:22:08 GMT

Apologie, I see your custom sort requirement now.

I'd advise you to add another field called SortProductName, with the product name (or just the first 10 characters of the product name) in it if performance is an issue, and with your product set to 'aaaaaaaaaa'. You can then got to the Sort properties, tick Expression, set to only(SortProductName).

Jonathan