Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (2)
6 Replies
MVP
MVP

Re: Sort order

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

Re: Sort order

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

er_mohit
Honored Contributor II

Re: Sort order

Not applicable

Re: Sort order

Hi Jonathan,

Thanks for the reply but it is not working

MVP
MVP

Re: Sort order

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

Re: Sort order

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.

Community Browser