Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
New 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

 

 

 

 

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: sort a chart by custom oder not working


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
Highlighted
MVP & Luminary
MVP & Luminary

Re: sort a chart by custom oder not working


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