Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
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
sunny_talwar

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?

Capture.PNG

View solution in original post

4 Replies
niclaz79
Partner - Creator III
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.

sunny_talwar

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?

Capture.PNG

samuel_brierley
Creator
Creator
Author

thanks that is correct and yes i had added some additional directions in inline load. oops.

thanks for the help.

sasiparupudi1
Master III
Master III

Add a pick to your sort expression

=Pick(match([Wind Direction],'N','NNE','NE','ENE','E','ESE','SE','SSE','S','SSW','W','WSW','W','WNW','NW','NNW'),1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16)

hth

Sasi