Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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