qliksense

[Mahamed_Qlik]

How to write in qliksense script for below query

select count(distinct PO_HEADER_ID)from FACT_BI_PO_HEADERS_ALL where PO_HEADER_ID not in(select PO_HEADER_ID from FACT_BI_RECEIPT)and TYPE_LOOKUP_CODE='STANDARD'

[Bunim]

FACT_BI_RECEIPT:   
Load
       PO_HEADER_ID
From
      FACT_BI_RECEIPT
      and TYPE_LOOKUP_CODE='STANDARD';

FACT_BI_PO_HEADERS_ALL:
Load
         count(distinct PO_HEADER_ID);
Load
         PO_HEADER_ID
Resident
        FACT_BI_PO_HEADERS_ALL
where
       not exist(PO_HEADER_ID);     

Drop Table FACT_BI_RECEIPT;