If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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') )
Remove Pick.... try this...
Match(Only({1} TicketStatus), 'Open', 'Assigned', 'Work In Progress', 'OnHold')
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') )
I tried in sort expression tab
none of the expression is working
any other suggestions?
Can you show the image of what you are seeing?
see below
used this
match(only({1} TicketStatus),'Open','Assigned','Work In Progress','On Hold (3rd Party)','On Hold (Customer)')
May be try with WilMatch
WildMatch(Only({1} TicketStatus), '*Open*', '*Assigned*', '*Work In Progress*', '*On Hold (3rd Party)*', '*On Hold (Customer)*')
still no change
Have you made sure that this sorting is over any other field or measure in the properties?
no other