Discussion Board for collaboration on QlikView Scripting.
I have this data format:
I want to fill up the Name between the timestamp.
order by the key and timestamp.
I hope someone can help me
Go to Solution.
if(Key = peek('Key') and isnull(Name),peek('Name'),Name) as Name
order by Key, Timestamp;
If I understand you correctly, maybe something like this?
If(Key=Previous(Key), 1, 2) as ID_Key,
(ooxml, embedded labels, table is Sheet1, filters(
Replace(1, top, StrCnd(null)),
Replace(3, top, StrCnd(null))
If(IterNo()=ID_Key, Key) as Key,
If(IterNo()=ID_Key, Timestamp(Timestamp), Name) as Timestamp
DROP Table Table1;
Format Timestamp determine what you need.
i want to have this:
If there is in same 'Key' two lines with the same "Name" and empty 'Name' between the 'Timestamp', it should fill up the "Name".
PFA fr the same..
Check the script aswell ..Data also attached in excel sheet 2
Find excel as well..Sorry I think I missed excel attachment..
if(isnull(Name),Peek(Name),Name) as Name
order by Key,Timestamp;
Hope it will work
I had to use len(Name) = 0
Its better to use
if(len(Trim(Name)) = 0)
Make sure to use trim to avoid necessary spaces..