topic Re: Removing row's by closest Date in QlikView

Removing row's by closest Date

Marv0Mat — Tue, 19 Oct 2021 12:11:52 GMT

Hello there,

i have some duplicated rows in a table which differ in a Date("Datum_Verbund") and an Object Number ("Fz_Nr_Verbund").

I only want the rows, which are the closest to the Date "Beg_Datum" but not newer then it, like this:

But i can't use the Max Date cause the Date "Beg_Datum" can be older then the Date "Datum_Verbund".

Thank you in advance!

Re: Removing row's by closest Date

MarcoWedel — Wed, 20 Oct 2021 20:53:38 GMT

are you looking for a front end or a script solution?

Re: Removing row's by closest Date

Marv0Mat — Wed, 27 Oct 2021 08:55:59 GMT

I'm looking for a script solution. In the meantime i have done it by myself. I made a Mappingtable with the condition: not newer then Beg_Datum and then the newest. I applyed the map and only took the rows where the Datum_Verbund is the same like my Mapped Date. But let me know if there is an easyer way to do it 😉