Discussion Board for collaboration on QlikView Scripting.
I'm new to Qlikview scripting and have found the forum invaluable for helping me overcome problems but I can't find an answer to this one. I have an input table that looks similar to this:-
I would like to load only the most recent date for each unique combination of Transaction Ref & Action Description so that the table loaded looks like this:-
Any help or hints on how I should script this would be really appreciated.
Go to Solution.
below script will help you resolve the issue
test:LOAD [Transaction Ref], [Action Description], num([Action Date]) as [Action Date]FROM..\test.xlsx(ooxml, embedded labels, table is Sheet3);NoConcatenateLOAD [Transaction Ref], [Action Description], Max([Action Date]) as Action_DateREsident testGroup by[Transaction Ref], [Action Description]; drop table test;
After reloaded the application , the Action_Date field to be converted to Date(Action_Date,'M/D/YYYY')
Sorry - Gremlins in my table. The output should be as above.
So straightforward. I was overcomplicating things looking at things like FirstSortedValue().
Many, many thanks!