Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to get get the last date for each part number received into seperate field in the load scripTt what is the best way to go about this ?
You could do as in script below. First pick out the max date per part and then join in the qty for that date.
Max(date) as date
LEFT JOIN (Data)
FROM Excel.xlsx (...);
View solution in original post
Thanks for that but what if I wanted to just have the max date for that part only with the qty ?
How would I do that ?