Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)