topic Re: How do I do a custom sort on text values? in QlikView

How do I do a custom sort on text values?

Thu, 02 Apr 2015 14:46:21 GMT

I have a chart that I want sorted as follows:

Past Due

Today

Due w/in 5 Days

Due Beyond 5 Days

I have added the following expression in the sort tab in the chart properties:

Match(vAGING_ORDER_BUCKET,'Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days')

This is not working as I want with the chart sorting like this instead (whether I choose Ascending or Descending - makes no difference - not that I expected it too):

Due Beyond 5 Days

Past Due

Due w/in 5 Days

Today

Ideas??

Re: How do I do a custom sort on text values?

prieper — Thu, 02 Apr 2015 15:34:32 GMT

This formula should work, if vAGING_ORDER_BUCKET is a fieldname.

HTH Peter

Re: How do I do a custom sort on text values?

MK_QSL — Thu, 02 Apr 2015 15:38:48 GMT

use

Only({1}Match('$(vAGING_ORDER_BUCKET)','Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days'))

Only({1}Match(vAGING_ORDER_BUCKET,'Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days'))

Re: How do I do a custom sort on text values?

Thu, 02 Apr 2015 16:07:25 GMT

Thanks for the quick reply. It is a variable not a field. As I'm new to this, I guess that matters. That being the case, do you have another suggestion? I tried the other suggestion by Manish and I still get the same result.

Re: How do I do a custom sort on text values?

Thu, 02 Apr 2015 16:08:19 GMT

Thanks for the reply. I'm still getting the same result though. As I said to Peter's reply, I'm using a variable and not a field.

Re: How do I do a custom sort on text values?

Thu, 02 Apr 2015 16:13:29 GMT

I tried the first suggestion by Manish with the $ (which I didn't do the first time - my bad) and it worked! Thank you so much.