Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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
Highlighted

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

View solution in original post

14 Replies
Highlighted

Re: order not workin

Remove Pick.... try this...

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

Highlighted

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

View solution in original post

Highlighted
Specialist III
Specialist III

Re: order not workin

I tried in sort expression tab

none of the expression is working 

any other suggestions?

Highlighted

Re: order not workin

Can you show the image of what you are seeing?

Highlighted
Specialist III
Specialist 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

Highlighted

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

Highlighted
Specialist III
Specialist III

Re: order not workin

still no change

No order.PNG

Highlighted

Re: order not workin

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

Highlighted
Specialist III
Specialist III

Re: order not workin

no other