topic help with sort order in QlikView

help with sort order

Anonymous — Mon, 26 Nov 2012 21:46:35 GMT

Hi,

I have 70 fields with fields values

avg,

high,

less

but i want the sort order as

high,

avg,

less

i can write a sort expression like Match(filedname,'high','Avg','Less') but this expression has to be written in all 75 list boxes (which i think will have lot of performance issue)

and i can have inline sort order table but i have around 75 fileds which needs to be sorted.

Any optimal and ideal solution please ?

Re: help with sort order

shree909 — Mon, 26 Nov 2012 21:54:48 GMT

Hi in the script itself do order by

load

avg,

high,

less

from table a

order by

avg,

high,

less;

Re: help with sort order

Anonymous — Mon, 26 Nov 2012 22:10:48 GMT

thanks for the reply shree..

but there are fields values like

fieldname - likelihood of purchasing a vechicle

and field values are like this

avg,

high,

less