topic Re: Sort dimension that has integer and alphanumeric values in QlikView

Sort dimension that has integer and alphanumeric values

cloud — Sat, 16 Nov 2024 21:02:11 GMT

hi,

I have a 'no. of month' dimension. it has values ranging from integers to alphanumeric eg. 5,1,7,6, < 1 Month

How do I sort such that '7' is at the top, descending all the way till '1' and '< 1 Month' is at the bottom below '1'

any help is appreciated! thanks.

Claudiu_Anghelescu — Wed, 17 Apr 2019 07:14:15 GMT

Sort -> Expression->

=match(only({1} [no. of month]), '7','6','5','1','<1')

cloud — Wed, 17 Apr 2019 09:01:18 GMT

hi claudiu,

I'm looking for an dynamic expression instead of static input. thank you.