Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

SORT PROPERTIES

hi !!

could anyone help me with the sort properties?

i have attached an excel file with my issue..

you see i want to sort  some sizes in order because qlick sawing them to me a little bit stirred

qlick saws (14,15,16,14H,15H,16H) and i want (14,14H,15,15H,16,16H)

is there an expression for this???


thank you!

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: SORT PROPERTIES

You're welcome. if you found my solution correct, could you mark my answer as correct? This way the thread is closed, so others know no more help is required. Also others with a similar problem might find a solution to their problem easier.

3 Replies
stigchel
Honored Contributor

Re: SORT PROPERTIES

In sort tab check the sort by expression only and use something like

=KeepChar(SIZEDESCR,'0123456789')

Not applicable

Re: SORT PROPERTIES

thank you very much!!

stigchel
Honored Contributor

Re: SORT PROPERTIES

You're welcome. if you found my solution correct, could you mark my answer as correct? This way the thread is closed, so others know no more help is required. Also others with a similar problem might find a solution to their problem easier.

Community Browser