Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ramya_beginner
Contributor

Cannot Sort

Hi

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.

Tags (1)
1 Solution

Accepted Solutions
llauses243
Contributor III

Cannot Sort

Hi Ramya,

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

Good luck, Luis

View solution in original post

3 Replies
Not applicable

Cannot Sort

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.

Not applicable

Cannot Sort

Hi Ramya,

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

llauses243
Contributor III

Cannot Sort

Hi Ramya,

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

Good luck, Luis

View solution in original post