https://community.qlik.com/t5/App-Development/Pick-Wildmatch-not-working/m-p/1893944#M73733 <P>I am using the following expression in the filter pane to list five items in the dropdown. But it only shows 1st, 3rd and 5th item. Can anyone help me understand why it is not showing all the items in the dropdown?</P> <P>=Pick(Wildmatch([DATACOLUMN],'*ON*','*FR*','*AB*','*QC*','*EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')</P> Wed, 16 Feb 2022 19:19:53 GMT virenjoshi 2022-02-16T19:19:53Z https://community.qlik.com/t5/App-Development/Pick-Wildmatch-not-working/m-p/1893944#M73733 <P>I am using the following expression in the filter pane to list five items in the dropdown. But it only shows 1st, 3rd and 5th item. Can anyone help me understand why it is not showing all the items in the dropdown?</P> <P>=Pick(Wildmatch([DATACOLUMN],'*ON*','*FR*','*AB*','*QC*','*EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')</P> Wed, 16 Feb 2022 19:19:53 GMT https://community.qlik.com/t5/App-Development/Pick-Wildmatch-not-working/m-p/1893944#M73733 virenjoshi 2022-02-16T19:19:53Z https://community.qlik.com/t5/App-Development/Pick-Wildmatch-not-working/m-p/1895175#M73855 <P>What about this?</P> <P><SPAN>=Pick(Wildmatch([DATACOLUMN],'ON*','FR*','AL*','QU*','EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')</SPAN></P> Sun, 20 Feb 2022 22:28:06 GMT https://community.qlik.com/t5/App-Development/Pick-Wildmatch-not-working/m-p/1895175#M73855 Thiago_Justen_ 2022-02-20T22:28:06Z