Discussion Board for collaboration related to QlikView App Development.
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.
This is my offer ... pls see image & .rar
Good luck, Luis
View solution in original post
The other way you can try is have the pending category in an another table like
And sort it by id. I hope what you have done is working fine.
Also you can remove the appended alphabets and try text (feildname)