new to qlik

[Mahamed_Qlik]

Hi Experts,

How to write script for below query:

select sum(B.QUANTITY*B.UNIT_PRICE)
from DIM_Table1 A,
DIM_Table2 B,
DIM_Table3 C,
FACT_Table4 D

where A.AUTHORIZATION_STATUS='APPROVED'
and A.REQUISITION_HEADER_ID=B.REQUISITION_HEADER_ID
and B.REQUISITION_LINE_ID=C.REQUISITION_LINE_ID
and C.DISTRIBUTION_ID<>D.REQ_DISTRIBUTION_ID

[Taoufiq_Zarra]

@Mahamed_Qlik  can you share a sample data ?

[Mahamed_Qlik]

I just need how we can write in script editor