topic Re: Sort not working in QlikView

Sort not working

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Sort not working

niclaz79 — Mon, 05 Mar 2018 12:08:25 GMT

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.

Re: Sort not working

sunny_talwar — Mon, 05 Mar 2018 12:08:41 GMT

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?

Re: Sort not working

samuel_brierley — Mon, 05 Mar 2018 12:24:20 GMT

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

thanks for the help.

Re: Sort not working

sasiparupudi1 — Mon, 05 Mar 2018 12:39:45 GMT

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