Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Syed17
Contributor III
Contributor III

SQL query to qliksense script

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)".

2 Replies
Milaf
Contributor III
Contributor III

Hi, I think that's it.

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

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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