Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
BlazkoG
Contributor III
Contributor III

selective data load, advanced load filter

Hi, I have transactions table, with in and out operations. Columns: date, quantity, part number, type (in, out), operation number.

So i want to cut out on load paired transactions that has the same quatinty, but  are opposite to each other.
I made it out to mark the ones that accur on the same day (daily sum = 0), and avoid loading them (table with items where daily sum is <>0, then left keep load)

load.jpg

as example, I want to load only the yellow marked line. 5 and -5 give 0.

Is it possible? Thanks in advane for any reply.

Labels (2)
0 Replies