Discussion Board for collaboration related to QlikView App Development.
I've got a list of sales order archives with a number of versions.
How do I write my script to only look at the latest version of each sales order?
Each sales order does not have the same number of versions.
See attached test data.
Please try this code
LOAD * INLINE [
SOnumber, VersionNumber, Amount, Date
inner keep load
max(VersionNumber) as VersionNumber
group by SOnumber;
drop table LatestVersion;
cleveranjos , i got this idea from your post, thanks
View solution in original post
Good to read that, keep in touch!