Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Absence Chart

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

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Absence Chart

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

View solution in original post

3 Replies
Highlighted
Contributor III
Contributor III

Re: Absence Chart

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Absence Chart

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 ??

Highlighted
Contributor III
Contributor III

Re: Absence Chart

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