topic custom sort dimension - number in QlikView

custom sort dimension - number

Mon, 02 Sep 2013 11:59:41 GMT

hi i would like to have a custom sort function on the dimension itemnumber

so that all the numbers beginning with 9 come first in the list.

i have tried the following ;

=match(left,Itemnumber,1))

Best,

Bradley

michael_maeuser — Mon, 02 Sep 2013 12:07:35 GMT

i would create a field in the script,

if(left(itemnumber, 1)=9, 1, 2 as xxx

and then sort by that field ascending

swuehl — Mon, 02 Sep 2013 12:08:01 GMT

Maybe like this:

= -match(left(Value,1),9)

or even just

= -left(Value,1)

as sort expression. But how do you want to sort the other values?

christophebrault — Mon, 02 Sep 2013 12:11:23 GMT

Hi,

if(Left(Value,1)=9,-1,Value) and sort ascending.