Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Creator

Sort not working

Hi all,

im trying to put together a type of wind gauge using a RADAR Chart. i bviously want the directions to go around in the logical fashion. to acheive this is have done this.

=match([Wind Direction],'N','NNE','NE','ENE','E','ESE','SE','SSE',

'S','SSW','W','WSW','W','WNW','NW','NNW')

the thing is the result is nonse. please attached. any help is appreciated.

p.s i have also tried using an inline load to provide id's to each and sorting on that value. no use.

thanks for any help.

1 Solution

Accepted Solutions
MVP

Try this for the sort expression

=Match(Only({1}[Wind Direction]),'N','NNE','NE','EEN','E','ESE','SE','SSE',

'S','SSW', 'SW', 'WSW', 'W','WSW','W','WNW','NW','NNW')

But do you have extra directions?

4 Replies
Partner - Creator III

Hi, Try this for sort order:

Aggr(Max({1}id),[Wind Direction])

Also, there were no id values for 'SSW' or 'WSW' which causes the above to be a bit off (they return null and end up on top). If you add those the above should work.

MVP

Try this for the sort expression

=Match(Only({1}[Wind Direction]),'N','NNE','NE','EEN','E','ESE','SE','SSE',

'S','SSW', 'SW', 'WSW', 'W','WSW','W','WNW','NW','NNW')

But do you have extra directions?

Creator
Author

thanks for the help.

Master III