Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
soniasweety
Valued Contributor III

order not workin

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

Tags (3)
1 Solution

Accepted Solutions

Re: order not workin

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') )

14 Replies

Re: order not workin

Remove Pick.... try this...

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

Re: order not workin

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
Valued Contributor III

Re: order not workin

I tried in sort expression tab

none of the expression is working 

any other suggestions?

Re: order not workin

Can you show the image of what you are seeing?

soniasweety
Valued Contributor III

Re: order not workin

see below

used this

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

order.PNG

Re: order not workin

May be try with WilMatch

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

soniasweety
Valued Contributor III

Re: order not workin

still no change

No order.PNG

Re: order not workin

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

soniasweety
Valued Contributor III

Re: order not workin

no other