Discussion Board for collaboration on QlikView Scripting.
I have this data format:
I need the Table like this:
So if the field "End" isnull, then it should take the data from the next line from "End".
And if there is no next line in the field "End" it should take the data from today.
And grouped by the field "Key".
I hope someone can help me.
Go to Solution.
Maybe something like
SET TIMESTAMPFORMAT = 'DD.MM.YYYY hh:mm:ss';
(html, codepage is 1252, embedded labels, table is @1);
LOAD Key, Time, Start, If(Start,If(Previous(Key)=Key and Len(Trim(End))=0, Alt(Previous(End),Now(1)), Timestamp(Alt(End,Now(1))))) as End
Order By Key, Time desc;
DROP TABLE Input;
Thank you very much!