Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)".
Hi, I think that's it.
IF(pl.lease_id = d.Lastest_lease_id, 'Yes', 'No') as "Latest Lease (Yes/NO)"
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