Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

Flag field based on string data in multiple fields

Hi There,

I want to create a new flag field whenever the term  below terms are found in Name or Desc columns.

CD or Disc or CD Disc

 

ID Name Desc Pos
6957 GBC Poly Designer Binding Covers Office Supplies Disc OFF-BI-10000320
6958 HTC One Mini Technology OFF-AR-10004999
6959 Laser & Ink Jet Business Envelopes Office Supplies Disc OFF-BI-10001116
6960 Cardinal Holdit Data CD Disc Pockets Office Supplies OFF-AP-10002651
6961 HTC One Mini CD Furniture OFF-AP-10001634

 

Please suggest.

Thanks

Labels (2)
1 Solution

Accepted Solutions
Marijn
Contributor III
Contributor III

You can use substringcount:

if(SubStringCount(Name&Desc, CD) >0 or SubStringCount(Name&Desc,Disc) >0, 1, 0) as Flag

View solution in original post

3 Replies
Marijn
Contributor III
Contributor III

You can use substringcount:

if(SubStringCount(Name&Desc, CD) >0 or SubStringCount(Name&Desc,Disc) >0, 1, 0) as Flag

surajap123
Creator II
Creator II
Author

Thank you so much @Marijn 

Marijn
Contributor III
Contributor III

You're welcome @surajap123 !