Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to solve this query into qliksense script
Where
(
( Nvl(pts7.actual_amount,0)>0 and nvl(PIs7.ACTUAL_AMOUNT,0)>0)
) and NVL(pis7.TRANSFERRED_TO_AP_FLAG,'N')='Y';
Try this:
WHERE
(
If(IsNull(pts7.actual_amount), 0, pts7.actual_amount) > 0
and If(IsNull(PIs7.ACTUAL_AMOUNT), 0, PIs7.ACTUAL_AMOUNT) > 0
)
and If(IsNull(pis7.TRANSFERRED_TO_AP_FLAG), 'N', pis7.TRANSFERRED_TO_AP_FLAG) = 'Y'
;
Try this
create one flag as newfield
IF(LEN(TRIM(pis7.TRANSFERRED_TO_AP_FLAG))=0,'N', 'Y') as Flag
and remaining should be in where condition to filter
LEN(TRIM(pts7.actual_amount))>0 and LEN(TRIM(PIs7.ACTUAL_AMOUNT))>0)