Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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