topic Re: Any idea about sorting ? in QlikView

Any idea about sorting ?

Anonymous — Mon, 10 Sep 2012 17:15:32 GMT

I have a list box , and I want to sort it in ascending or decendinging order.

The list box contains aphanumberic values...I'm attaching the app..I tried doing by going to the properties,sort tab.. the thing is it only works if data is numeric or has alphabets..doesn't work for alphanumeric.

any ideas

thnx

Re: Any idea about sorting ?

whiteline — Mon, 10 Sep 2012 18:03:16 GMT

If you choose Sort by expression you should write that expression. For example =AC_AGE

But there is an easier way. Use dual function as a listbox expression:

=dual(FLOOR(AC_AGE)&'Years '&(AC_AGE - FLOOR(AC_AGE))*12 & ' Months', AC_AGE)

This returns dual value - numeric AC_AGE with your complex text format.

Then you can sort it just by Numeric Value.

The same trick works with calculated dimension, use:

=dual(FLOOR(AC_AGE)&'Years '&(AC_AGE - FLOOR(AC_AGE))*12 & ' Months', AC_AGE)

and sort it as number.

Re: Any idea about sorting ?

Mon, 10 Sep 2012 21:12:27 GMT

Just sort by AC_AGE. See attached.

Re: Any idea about sorting ?

Anonymous — Tue, 11 Sep 2012 14:48:45 GMT

Thank you Whitline and rebeccad..the solutions given by both of you works perfect..