topic Re: reg-sorting in straight table in QlikView

reg-sorting in straight table

Fri, 17 Apr 2015 03:01:00 GMT

Hi iam getting error is sorting in straight table and i have to get the names of correctly under BU COLOUMN.

ethical

diabetes

oncology

promoted

chc

but iam getting oncology

ethical

diabtes

promoted

chc

and i have given Ascending in the sort tab and give expression as Order_BU.

IN THE UAT AND DEV ENVIRONMENT THE ORDER IS CORRECT BUT IN PROD THE ORDER IS DIFF...CAN ANYONE HELP ME OUT.

Fri, 17 Apr 2015 03:26:25 GMT

could you please share the sample app.

Fri, 17 Apr 2015 04:01:18 GMT

i have attached the screen shot

amit_saini — Fri, 17 Apr 2015 04:24:02 GMT

Rao,

Try this in your sort Expression:

Dual(BU,Match(BU,'ethical', 'diabete', 'oncology', 'promoted', 'chc'))

Second option:

Create Inline table like below and call BU_New filed instead of BU

Load * Inline [

BU , BU_New

Oncology ,ethical

ethical ,diabtes

diabtes ,Oncology

promoted ,promoted

chc ,chc

];

Thanks,