topic Re: Sort by Expression not working in App Development

Sort by Expression not working

imsohotness — Tue, 06 Aug 2019 13:01:17 GMT

Good morning everyone,

I'm trying to use the Match function to custom sort text values in a certain field for my pie charts, but it doesn't work. Here is my expression:

=Match([Item 3: Length of Service],'More than 5 years','3-5 years','1-2 years','Less than 1 year')

Here is a quick video explaining my issue. Sorry for the poor sound quality.

Re: Sort by Expression not working

sergio0592 — Tue, 06 Aug 2019 09:44:23 GMT

Hi,

Where do you want to sort? In a stacked bar?

Re: Sort by Expression not working

imsohotness — Tue, 06 Aug 2019 10:14:39 GMT

Trying to do a Pie chart. I want the values to show up in the correct order in the legend.

Re: Sort by Expression not working

sergio0592 — Tue, 06 Aug 2019 11:26:28 GMT

When i create a sample with your formula, i have a correct order. In lengend settings, have you tried "reverse order"?

Re: Sort by Expression not working

imsohotness — Tue, 06 Aug 2019 13:02:29 GMT

I have tried to reverse the sort order, but to no avail.

Here is a quick video explaining my issue. Sorry for the poor sound quality.

Seems like it should be so straightforward but it's not and its driving me crazy.

Thanks for your help.

Re: Sort by Expression not working

Or — Tue, 06 Aug 2019 13:14:24 GMT

I think you might be in the wrong forum, looks like you're asking about Qlik Sense, not QlikView...

When dealing with sorting issues, I've always had the most luck by setting up the fields in question as Dual() types in my script (you can also create a duplicate of the field in your script as a dual and keep the original), with the numeric aspect then used to control the sort order. If you only have four values, which seems to be the case, you should be able to do that without too much trouble.

Re: Sort by Expression not working

sergio0592 — Tue, 06 Aug 2019 13:17:14 GMT

Thanks for your video. But you're on Sense not VIew. But, both should have the same behaviour.

Re: Sort by Expression not working

imsohotness — Tue, 06 Aug 2019 13:25:11 GMT

Thanks for your suggestion. I will try this, but I am not sure how to go about it. Is it something that can be done from the sheet view or do I need to unlock the data load editor?

Re: Sort by Expression not working

sergio0592 — Tue, 06 Aug 2019 13:33:22 GMT

In your load statement, try with :

LOAD dual (Length, Num_lengt) as Length_of_service INLINE [ Length, Num_lengt More than 5 years,4 3-5 years,3 1-2 years,2 Less than 1 year,1 ];

Re: Sort by Expression not working

Claudiu_Anghelescu — Tue, 06 Aug 2019 14:30:08 GMT

=Match(only({1} [Item 3: Length of Service]),'More than 5 years','3-5 years','1-2 years','Less than 1 year')

Re: Sort by Expression not working

imsohotness — Tue, 06 Aug 2019 14:51:34 GMT

I've tried both, but the values refuse to sort. They won't budge.

Why is this so complicated??