Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

Value based on values in 3 different columns in Straight tbl

Hi There,

I have below calculated field in the script, which look for a specific string ie CD & Disc  in Name and Desc fields to flag it.

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

I want to move this logic from script to directly in a straight table.

This means I want substringcount() to look for values in the adjacent columns(Name and Desc) in the straight table and create a flag in the Flag column.

Please help.

 

 

Labels (1)
1 Reply
edwin
Master II
Master II

substringcount is a chart function as well so you can straight away use that in your column.  if Name and Desc are fields and is included in your straight table you can use that as well.  however, if for some reason you need to check the table columns based on the position in your table you can use the column function 

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/In...

or depending on how you name your columns, you can address the columns using the column names (not field names)