Convert Sql query into Qliksense

[Syed17]

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';

[igoralcantara]

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'

;

[qv_testing]

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)