topic Re: Sort Function in QlikView

Sort Function

Mon, 03 Mar 2014 21:09:12 GMT

hope to do the following.

i have a column whereby i show color codes, i.e

Color

i would like the colors to sort in order but have 39 always last. Alternatively i would like to use the description of 39 for the totals row. and discard 39 from the color column. As i have over 150 colors Match seems like a daunting task, is there any good code to save time in this case.

Re: Sort Function

Mon, 03 Mar 2014 21:20:33 GMT

Bradley,

If Color is a dimension, do the following:

1) LOAD INLINE

with the order you wish

Script: load your tables (incl. Color)

2) SORT by LOAD order in the UI

QV keep the first order used to populate the table. So do not delete this field during the script. And use this load order in the UI.

Fabrice

Re: Sort Function

rwunderlich — Mon, 03 Mar 2014 22:48:43 GMT

You can actually DROP the INLINE sort table at the end of the script. The load order will be preserved through the load of your fact tables.

-Rob