I am getting my data from an excel spreadsheet which pushes the correct data range in Microsoft SQL database and loading it in to QlikSense
My problem is, when a user updates a field within the spreadsheet it adds a new line of field in the database and then duplicates that data with a unique ID in Qlik (Technically its not unique as it has a unique ID).
What i was hoping is can I show data for the MAX date and dis include any values before that date?
There may be faster ways to do this (for example by first using the GROUP BY & FirstSortedValue combo on the unique row ID and then joining the rest) and the logic may not be applicable if Supplier isn't your only grouping field, but this would work for you example I guess:
FirstSortedValue(Location, -[Date Created]) AS Location,
FirstSortedValue([Delivery Date], -[Date Created]) AS [Delivery Date],