topic Cannot Sort in QlikView

Cannot Sort

Anonymous — Thu, 07 Apr 2011 00:22:21 GMT

I need to get the PendCategory values to be sorted on the x axis , i have tried multiple ways for this but nothing seems to work , any help is greatly appreciated .

Ways i tried to sort.

1.Regular sort options did not work

2.Apended alphabets a,b,c .... , to the pend_category and gave the calculated dimension to avoid abc on the graph and gave sorting by expression using apended column

3.Created a new column pendcategory_rank and used that column as expression.

I have attached my working document , please help me in sorting properly ,let me know if code needs to changed.

Thanks you.

Cannot Sort

Thu, 07 Apr 2011 07:46:57 GMT

Hi Ramya,

The other way you can try is have the pending category in an another table like

id pend_category

1 >0&<3sec

2 >3&<=5sec

3 >5sec

And sort it by id. I hope what you have done is working fine.

Cannot Sort

Thu, 07 Apr 2011 07:53:26 GMT

Hi Ramya,

Also you can remove the appended alphabets and try text (feildname)

Cannot Sort

llauses243 — Thu, 07 Apr 2011 09:08:45 GMT

Hi Ramya,

This is my offer ... pls see image & .rar

Good luck, Luis