order not workin

[soniasweety]

Hi all,

Sort order is not working in Qliksense bar chart

tried with match still no luck

pick(match(TicketStatus,'Open','Assigned','Work In Progress','OnHold'),'Open','Assigned','Work In Progress','OnHold')

the above order I want

but am getting       open, work in progrees, onhold,assigned

[vkish16161]

Sony,

I encountered this issue before. For this, it's best to create a numeric flag in the script and use that flag for sorting.

[soniasweety]

Hi,

can you tell me how to write the code in script?

how can join the table aswell?

after creating how to use that sort order in chart?

[vkish16161]

num(pick(match(TicketStatus,'Open','Assigned','Work In Progress','OnHold'),1,2,3,4) as Sorting_Flag    

This flag can be used in the same table and does not require a join.

You can use this field in the sorting criteria.

[passionate]

Try using pick(match(TicketStatus,'Open','Assigned','Work In Progress','OnHold'),1,2,3,4)

[soniasweety]

working well,

I used in both dimension and sort order tab also.