topic Re: Absence Chart in QlikView

Absence Chart

snowman — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I have a simple table of 2 fields: timestamp (time-date) and employee ID. The timecard system will mark a record when an employee checks the timecard system everyday when he comes to work.

How can I make a table or chart that shows the absence (or presence) dates of all employees for a month ?

Thanks

Re: Absence Chart

docpuddu — Fri, 15 Nov 2019 11:24:59 GMT

Hi snowman,
to some extent this is an "heatmap scenario".

I found this article very helpful and I think the solution showed in it can be adaped to your case as well.

https://qlikfreak.wordpress.com/2014/03/09/heat-map/

HTH.

Ciao,
/Andrea

Re: Absence Chart

snowman — Fri, 15 Nov 2019 16:29:32 GMT

Thank you, Docpuddu. It is more than what I need, and a nice article indeed.

One more thing I need to add, of which I searched from the community, is that my timestamp even though Load as Date, the Date gives multiple records for the same date, and I need to use this script expression to Load the Date:

Load Date(Floor(Date(timestamp))) AS Date

I wonder if simply use: Load Date(timestamp) AS Date

the system will still keep the time portion of the timestamp in the Date field and show multiple records for the same date ??

Re: Absence Chart

docpuddu — Mon, 18 Nov 2019 09:07:36 GMT

Hi Snowman, briefly...

- Date(timestamp) cuts the time part so Date(18/11/2019 09:56) -> 18/11/2019

- Wrapping Date(timestamp) with Date(Floor( ... )) doesn't change the Date behaviour

not sure, I've answered... HTH anyway.

Ciao,
/Andrea