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

[sunny_talwar]

Remove Pick.... try this...

Match(Only({1} TicketStatus), 'Open', 'Assigned', 'Work In Progress', 'OnHold')

[its_anandrjs · Accepted solution]

Try some of this IN SORT ORDER

ONLY( {1} pick(match(TicketStatus,'Open','Assigned','Work In Progress','OnHold'),'Open','Assigned','Work In Progress','OnHold') )

Or

Match(TicketStatus,'Open','Assigned','Work In Progress','OnHold')

Or

Only({1} Match(TicketStatus,'Open','Assigned','Work In Progress','OnHold') )

Or

Only(Match(TicketStatus,'Open','Assigned','Work In Progress','OnHold') )

[soniasweety]

I tried in sort expression tab

none of the expression is working 

any other suggestions?

[sunny_talwar]

Can you show the image of what you are seeing?

[soniasweety]

see below

used this

match(only({1} TicketStatus),'Open','Assigned','Work In Progress','On Hold (3rd Party)','On Hold (Customer)')

[sunny_talwar]

May be try with WilMatch

WildMatch(Only({1} TicketStatus), '*Open*', '*Assigned*', '*Work In Progress*', '*On Hold (3rd Party)*', '*On Hold (Customer)*')

[soniasweety]

still no change

[sunny_talwar]

Have you made sure that this sorting is over any other field or measure in the properties?

[soniasweety]

no other