Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srikanthsri1
Valued Contributor

help with sort order

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 ?

2 Replies
shree909
Valued Contributor II

Re: help with sort order

Hi in the script itself do order by

load

avg,

high,

less

from table a

order by

avg,

high,

less;

srikanthsri1
Valued Contributor

Re: help with sort order

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

Community Browser