Help to convert Sql query to qliksense script

[Syed17]

decode (pl.lease_status,'ACT','Active','TER', 'Terminated',pl.lease_status)  "Lease Status"

,decode(pl.status,'F', 'Final','D','Draft','S','Submitted for Approval') "Lease Approval Status".   Please help me to convert this sql query into qliksense script using qvd field.

[rubenmarin · Accepted solution]

Hi, you could use mapping tables but for this few cases maybe just use a direct if:

LOAD Fields...
  If(lease_status='ACT'
    ,Active'
    ,If(lease_status='TER'
      ,'Terminated'
      ,lease_status)) as [Lease Status],
  If(status='F'
    ,'Final'
    ,If(status='D'
      ,'Draft'
      ,If(status='S'
        ,'Submitted for Approval'))) as [Lease Approval Status]
From/Resident...

[Syed17]

Thanks sir i got the exact solution what i need to get from that.