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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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