Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort order

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.

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

er_mohit
Master II
Master II

Not applicable
Author

Hi Jonathan,

Thanks for the reply but it is not working

jonathandienst
Partner - Champion III
Partner - Champion III

Try

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


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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.