I want to create a new column N that would look at the value of Column A, if Column A contains stream as 'abc', then the value of Column N should be 'Yes', if not contain 'abc', the value should be 'No'.
In excel, for Column N it is something like: =IF(ISNUMBER(SEARCH("abc",A1)),"Yes","No").
I want to do that in Qlik by adding a new Column and call it 'N'. How to do that? Thanks in advance