If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a column called Order_Tyoe where data are present as 'RGA001', 'ABC002', 'DEF03' in this way.
I want to create a calcuation like this one -- if substring (Order_Type), 3,0) = 'RGA' then 0 else 1
Not able to figure out which string function should I use.
May be this
If(Left(Order_Type, 3) = 'RGA', 0, 1) as Flag