Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I was assigned a task to create a dashboard for checking the punctuality of employees. The reference point will be 8:00 am. I am new to Qlikview. I need to know if someone can help me with this. I have attached the excel sheet of raw data below.
Venkatesh,
my code is like so:
Attendance:
LOAD *,
if(InTime>(8/24), 'Late', 'On Time') as OnTime;
LOAD *,
time(subfield([In Actual Date/Time], ' ', 2)) as InTime,
date(daystart([In Actual Date/Time])) as InDate;
LOAD [Employee Name],
Timestamp(Timestamp#([In Actual Date/Time], 'dd/mm/yyyy hh:mm')) as [In Actual Date/Time]
FROM
[Attendance qlik.xls.xlsx]
(ooxml, embedded labels, table is [Raw Data])
WHERE NOT IsNull([Employee Name]);
And some of the results:
can u please eloberate the scenario
Hi Vekatesh,
see the attached.
I've created a field - OnTime - to indicate whether an employee is in attendance at or before 8 am.
I'm not too sure what [In Selected Date/Time] is - is this derived?, so have used [In Actual Date/Time].
Marcus
Hi Praveen,
Sure. The task assigned to me is to create a real time dashboard for recording the arrival time of the employees in the company. But the format in which the data is being extracted was a combination of date and time, so I had to manually change it to the required format. I am not sure how to put the exact value in a chart because Qliksense allows functions like Sum, Count, Avg, Max, Min only. SO i was looking for an option to enter the date and time as it is without any functions. Hope this helps.
Thanks in advance
Hi Marcus,
Thank you so much for your help, but unfortunately my company is not providing the fund the purchase the full version of Qlikview. I was not able to open the qlikview file which you have sent me. So sorry for the trouble caused. But for the purpose of learning a new software, I had downloaded a trial version of Qlikview and Qliksense, so that I can improve my software skills. Is there any possibility to send a snapshot of the output which you have obtained through your analysis. Thanks in advance
Venkatesh,
my code is like so:
Attendance:
LOAD *,
if(InTime>(8/24), 'Late', 'On Time') as OnTime;
LOAD *,
time(subfield([In Actual Date/Time], ' ', 2)) as InTime,
date(daystart([In Actual Date/Time])) as InDate;
LOAD [Employee Name],
Timestamp(Timestamp#([In Actual Date/Time], 'dd/mm/yyyy hh:mm')) as [In Actual Date/Time]
FROM
[Attendance qlik.xls.xlsx]
(ooxml, embedded labels, table is [Raw Data])
WHERE NOT IsNull([Employee Name]);
And some of the results:
Thank you so much Marcus. Now I got a clear idea on how to formulate it.