Discussion Board for collaboration on QlikView Scripting.
I have several version of some orders,
Version 1: inquiry
version 2: passing
version 3: delivery
so, my intention is to get the last version.
there is a key: ArticleNr, and others like description, amount, ...
so, how can I tell in script, that Qlikview only import the lastes version of each Articlenr?
Load ArticleNr where MaxString(versionr),
description, amount ...
I hope you can understand this
LOAD ArcticleNr, max(versionnr) as versionnr
GROUP BY ArticleNr;
LOAD ArcticleNr, versionnr, ...other fields...