Discussion board where members can get started with QlikView.
I've a dated price list and for each item, I've to consider the latest starting dates (see excel file in attachment)
How can I solve this problem ?
I'm trying without success for a long time...
Thanks in advance for your support
(ooxml, embedded labels, table is Foglio1);
Max(From) as From
Group By ItmeNr;
View solution in original post
Two questions, what do you expect to see? Is this something you want to handle in script or front end of the application or you don't care
In this case, It' something I want to handle into the script. At the end of the loading, I should have only the yellow lines (see excel file) into my table
It works. Thanks for your help