topic Re: Sort order in QlikView

Sort order

Thu, 23 May 2013 09:37:57 GMT

Hi All,

I have a Region field with values ML,TW, HK and null (due to join condition).Now in the table I have added the dimension.I want to sort the data as ML,TW,HK and Null .

Could some one healp me in this please..

Thanks in advance.

Re: Sort order

jonathandienst — Thu, 23 May 2013 10:01:23 GMT

You could use something like this in your Sort dialog expression:

=If(IsNull(Region), 4, Match(Region, 'ML', 'TW', 'HK'))

Hope that helps

Jonathan

Re: Sort order

Thu, 23 May 2013 10:13:19 GMT

properties of chart--> sort --> check load order and uncheck other

Re: Sort order

er_mohit — Thu, 23 May 2013 10:28:21 GMT

See the link

http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/

hope it helps

Re: Sort order

Thu, 23 May 2013 11:16:32 GMT

Hi Jonathan,

Thanks for the reply but it is not working

Re: Sort order

jonathandienst — Thu, 23 May 2013 13:13:14 GMT

Try

=Aggr(If(IsNull(Region), 4, Match(Region, 'ML', 'TW', 'HK')), Region)

Re: Sort order

Fri, 24 May 2013 03:57:01 GMT

I have tried that as well but it is not working. Just for ur info I also have threee more field in the dimensions and some 5 expressions in the pivot table??

Is there any issue with the null values sorting in pivot table??

Thanks in advance.