Hi! i have to transform a SQL query in Qlikview and i'm working on the follow table, but there is a part of the original script in sQL that i'm not able to translate in Qlikview language. The part of the script is the following:
(case when INVOICE_COMPANY_ID in (SELECT DISTINCT company_id
WHERE SYSDATE BETWEEN start_date AND end_date AND company_id != '--')
then DECODE (INVOICE_COMPANY_ID, 'SI', 'RS', INVOICE_COMPANY_ID)
else 'RS' end) SITE_COMPANY_ID,
then there is all the script of the table that i've already converted. So some one can explain me how i can convert in qlikview the previous part ??
IF(isnull(INVOICE_EXPIRE_DATE), INVOICE_DATE, INVOICE_EXPIRE_DATE) as INVOICE_EXPIRE_DATE,