Hi I'm new to qliksense can any one help me out from this issue.
When i'm loading data the some cells are empty ,i want to fill those cells with above row cell data.is it possible in qliksense ..?
May be using Peek() function:
If(Peek('Field1') = Field1 and Len(Trim(Field2)) = 0, Peek('Field2'), Field2) as Field2
Order By Field1, Field2 desc;
DROP Table Table;
it is not working
This is a example table ,in the above table i want to place the empty cell into name with the above cell name and pic the min time and max time in a day for each person.
(For referring the names id's are available)
Would you be able to share a sample in Excel?
below i shared the example file..just have a look into that.
Try this script:
If(Len(Trim(NAME)) = 0, Peek('NAME'), NAME) as NAME,
(ooxml, embedded labels, table is Sheet1);
Thank you sunny,it's working correctly.can you send the code for picking start time and end time in a day for each person for the same table data
i tried with below code but its not working
min(TIME) as mintime,
max(TIME) as maxtime
group by NAME;
Left Join (Table)
Time(Max(TIME), 'hh:mm') as MAXTIME,
Time(Min(TIME), 'hh:mm') as MINTIME
Group By NAME, DATE;
Thank you sunny it is perfect.
Retrieving data ...