Discussion Board for collaboration on QlikView Scripting.
Hello community, I need help on this issue below
I have a table of payments, where I have a table of payments, where ID_CD_MOV = 10 (Payments done) and ID_CD_MOV = 11 (Payments reversed).
I have a table of payments, where my problem must disregard the payments reversed and disregard previous payments related to the reversal, as they have done again after receiving the cancelation
The table clearly shows what I need, the flag field does not exist in the database, just put as a reference to the need
Go to Solution.
I worked a bit of off the examples provided and this one works in this specific case.
However the arbitrary selection of what to match is causing me some trouble, as well as the possibility of having multiple same value negatives per id.
Might be a starting point for a real solution.
This reversal doesn't have a matching payment afaict.
If -1200 should be -1700 then I can match it. See attached example.
-1200 I have not had time to assemble wrong in the example, you are correct in that case held that the dates are the same at the time of making the comparison and if the dates are different example: