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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
virenjoshi
Contributor
Contributor

Pick(Wildmatch) not working

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?

=Pick(Wildmatch([DATACOLUMN],'*ON*','*FR*','*AB*','*QC*','*EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')

Labels (1)
1 Reply
Thiago_Justen_

What about this?

=Pick(Wildmatch([DATACOLUMN],'ON*','FR*','AL*','QU*','EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago