Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
wcilliers
Partner
Partner

Script Load where Sum(Amount) Greater Than Zero

Hi All,

I need some help in my load script. I am loading invoice headers and then joining the lines where my amount field gets read from. However, I want to exclude all invoices where the Sum(Amount) = 0.

What is the best way to approach this?

I have tried loading all into a temp table, then loading the fact as a resident from temp table where sum(Amount) > 0 and grouping by DocNumber. But it doesnt seem to work...

Any ideas?

1 Reply
Taoufiq_Zarra
Master II
Master II

@wcilliers  can you share a sample data and the expected ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉