how to change my expression for multi-selection possible

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

hi all

I have the expression like

= if ((KPI_Flag ='GF' or (TimeSpecial_1<>0 and DueDate>= MonthEnd and DueDate_1<>0)) and (Match(GetFieldSelections(MapColorSelection),'All','Green')),'Green',

if (KPI_Flag = 'YF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (Match(GetFieldSelections(MapColorSelection),'All','Yellow')) , 'Yellow',

if(KPI_Flag='RF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (Match(GetFieldSelections(MapColorSelection),'All','Red')),'Red')))

when I select Green it select only green value in the table

but when I select more than one value in list box this expression not working

how can i change this in expression level?

Re: how to change my expression for multi-selection possible

sunny_talwar — Mon, 26 Jun 2017 20:55:41 GMT

Try WildMatch instead of just Match

= if ((KPI_Flag ='GF' or (TimeSpecial_1<>0 and DueDate>= MonthEnd and DueDate_1<>0)) and (WildMatch(GetFieldSelections(MapColorSelection),'*All*','*Green*')),'Green',

if (KPI_Flag = 'YF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (WildMatch(GetFieldSelections(MapColorSelection),'*All*','*Yellow*')) , 'Yellow',

if(KPI_Flag='RF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (WildMatch(GetFieldSelections(MapColorSelection),'*All*','*Red*')),'Red')))

topic how to change my expression for multi-selection possible in QlikView

how to change my expression for multi-selection possible

Re: how to change my expression for multi-selection possible