topic Re: Look up values in a field in QlikView

Look up values in a field

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

How to search for specific text within a field that contains various information separated by commas ?

I set up a market research and multiple choice answers were built in the database by joining the Google Forms information and separating comma as the example . Need to separate the information . Thus , I thought to create three more columns that will function to search for text within a field and return it me or has not.

What your choice of colors : White , Black and Red ?	White	Black	Red
Black, Red	Not	Yes	Yes
White, Black	Yes	Yes	Not
White, Black, Red	Yes	Yes	Yes

Excel can result in using:

B2 =ISNUMBER(SEARCH("White";A2))

C2 =ISNUMBER(SEARCH("Black";A2))

D2 =ISNUMBER(SEARCH("Red";A2))

How to do this in Qlikview ?

Thanks.

Odair Jr.

Brazil

Re: Look up values in a field

Anonymous — Tue, 18 Nov 2014 19:10:30 GMT

B2 For White

Pick(WildMatch(YourFieldName, '*White*) + 1, 'No', 'Yes')

C2 For Black

Pick(WildMatch(YourFieldName, '*Black*) + 1, 'No', 'Yes')

D2 For Red

Pick(WildMatch(YourFieldName, '*Red*) + 1, 'No', 'Yes')

Re: Look up values in a field

morgankejerhag — Tue, 18 Nov 2014 19:18:45 GMT

A different approach - see the attached file.

if(SubStringCount(Colours,'Red'),'Yes','Not') as Red,

Re: Look up values in a field

Anonymous — Wed, 19 Nov 2014 01:44:55 GMT

This approach is cleaner.

Re: Look up values in a field

Anonymous — Wed, 19 Nov 2014 01:53:19 GMT

Thank you all for the answers . But I have another challenge.

And the color blue that was reported as a particular response and not listed in one answer arises?

Others need a column to manage the different colors of White , Black and Red.

What expression would the "Yes" results for Other column for Blue?

Re: Re: Look up values in a field

morgankejerhag — Wed, 19 Nov 2014 06:36:07 GMT

Here we handle unknown colors as well

purgechar(replace(replace(replace(Colours,'Red',''),'White',''),'Black',''),', ') as Other,

Re: Look up values in a field

Anonymous — Wed, 19 Nov 2014 11:46:10 GMT

Perfect Morgan , solved my problem.

Thanks.

topic Re: Look up values ​​in a field in QlikView

Look up values ​​in a field

Re: Look up values ​​in a field

Re: Look up values ​​in a field

Re: Look up values ​​in a field

Re: Look up values ​​in a field

Re: Re: Look up values ​​in a field

Re: Look up values ​​in a field

topic Re: Look up values in a field in QlikView

Look up values in a field

Re: Look up values in a field

Re: Look up values in a field

Re: Look up values in a field

Re: Look up values in a field

Re: Re: Look up values in a field

Re: Look up values in a field