topic Re: sort a chart by custom oder not working in QlikView

sort a chart by custom oder not working

paulista — Sat, 16 Nov 2024 19:25:42 GMT

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

Re: sort a chart by custom oder not working

Gysbert_Wassenaar — Wed, 18 Dec 2019 13:45:17 GMT

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.