Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
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)


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