Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

How and where to write conditional statement in qlikview

I have two fields .

Deviation after sounding and Difference vs Log survey:

I want to write a code that if the  difference between them is less than 2 then a new column will display yes against the value or else no.

if (Deviation after sounding) - (Difference vs Log survey) <=2 then (NEW COLUMN ) = "Correction done"

or else "Correction Not Done"

10 Replies
aslam24196
Contributor III
Contributor III

You can wirte this in the expression if you want to do it in the front end:

if(([Deviation after sounding] - [Difference vs Log survey]) <=2,'Correction Done','Correction Not Done')