Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In the photo, there are tables. And i have a 'case when' code about table association field. But i don't know how i change case when code to qlik sense script.
Case When Code:
CASE WHEN ftdinp <> 'N'
THEN (SELECT ibmyil||ibmrfc||ibmref FROM salibd,salibm
WHERE ibdunq = (SELECT spdkun FROM salspd
WHERE spdunq = ftdkun)
AND ibmyil = ibdyil
AND ibmrfc = ibdrfc
AND ibmref = ibdref
)
ELSE (SELECT ibmyil||ibmrfc||ibmref FROM salibd,salibm
WHERE ibdunq = (SELECT spdkun FROM salspd
WHERE spdunq = (SELECT irdkun FROM salird
WHERE irdunq = ftdkun)
)
AND ibmyil = ibdyil
AND ibmrfc = ibdrfc
AND ibmref = ibdref
)
END
Could you help me?
Accepted Solutions
