Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
cloud
New Contributor III

Sort dimension that has integer and alphanumeric values

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. 

2 Replies
Claudiu_Anghelescu
Contributor III

Re: Sort dimension that has integer and alphanumeric values

Sort -> Expression->

=match(only({1} [no. of month]), '7','6','5','1','<1')
To help community find solutions, please don't forget to mark as correct.
cloud
New Contributor III

Re: Sort dimension that has integer and alphanumeric values

hi claudiu,

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