Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
shreya1135
Contributor
Contributor

Qlik sense

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.

Labels (1)
1 Reply
sunny_talwar

May be this

If(Left(Order_Type, 3) = 'RGA', 0, 1) as Flag