Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Creator
Creator

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')