SQL query to qliksense script

[Syed17]

Hi everyone,   Please help me to convert this sql query into qliksense script using if function  decode(pl.lease_id,d.Lastest_lease_id,'Yes','No') "Latest Lease (Yes/NO)".

[Milaf]

Hi, I think that's it.

IF(pl.lease_id = d.Lastest_lease_id, 'Yes', 'No') as "Latest Lease (Yes/NO)"

[rwunderlich]

if(pl.lease_id = d.Lastest_lease_id,'Yes','No') as "Latest Lease (Yes/NO)"

See https://www.sqltutorial.org/sql-comparison-functions/sql-decode/

-Rob