Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulista
Contributor III
Contributor III

sort a chart by custom oder not working

 

Below is my expression :

Match(eventname,'MANUALCASECOMPLETED-CPVT-REJECTED
','APPROVEDATAOVERRIDE-REJECTED
','REVIEWCASECOMPLETED-CPVT-REJECTED
','CMREVIEWCOMPLETED-CM-REJECTED
','CONFIRMREQUESTCOMPLETED-CM-REJECTED
','REVIEWAMENDREQUESTCOMPLETED-CPVT-REJECTED
','BATCH-REJECTED
','REPORT-REJECTED
','DATAQACOMPLETED-REJECTED
','METHODOLOGYQACOMPLETED-REJECTED
','REVIEWREPORTCLAIMED-CM-REJECTED')

 

and snapshot of the graph. any idea why is not working

graph.PNG

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III


Match(eventname,'MANUALCASECOMPLETED-CPVT-REJECTED
','APPROVEDATAOVERRIDE-REJECTED
','REVIEWCASECOMPLETED-CPVT-REJECTED
','CMREVIEWCOMPLETED-CM-REJECTED

It looks like you include a line break in your labels. Do they really include a line break? If the eventname values don't and the labels you put in your match function do then they won't match.

You might also want to use Only({1} eventname) instead of just eventname to make sure selections don't mess up the sorting order.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III


Match(eventname,'MANUALCASECOMPLETED-CPVT-REJECTED
','APPROVEDATAOVERRIDE-REJECTED
','REVIEWCASECOMPLETED-CPVT-REJECTED
','CMREVIEWCOMPLETED-CM-REJECTED

It looks like you include a line break in your labels. Do they really include a line break? If the eventname values don't and the labels you put in your match function do then they won't match.

You might also want to use Only({1} eventname) instead of just eventname to make sure selections don't mess up the sorting order.


talk is cheap, supply exceeds demand