Sort order

[#1]

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.

[jonathandienst]

Hi

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

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

Hope that helps

Jonathan

[#3]

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

[er_mohit]

See the  link

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

hope it helps

[#5]

Hi Jonathan,

Thanks for the reply but it is not working

[jonathandienst]

Try

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

[#7]

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.