Re: expression for all date entries - Qlik Community

kakani87 · ‎2018-01-11

Dear All,

I'm having a data to display all the entries for an employee in all available dates

in the sample attached it is showing last entry but if we filter date wise this is not showing accordingly.

like Eid | Ename | Dates

01 A 11/01/2018

02 B 11/01/2018

.

01 A 10/01/2018

02 B 10/01/2018

.

02 B 09/01/2018

01 Emp entry not here for 09/01/2018 because there is no entry for him.

Any help is appereciable.

sunny_talwar · ‎2018-01-11

So what would you like to see for 01 if he doesn't have entry for a particular date?

kakani87 · ‎2018-01-11

Hi Sunny ... My intention is to display the list of absent people

I want to display the records where there will not be entries

i.e. list of people Absent in a day using biometric access data with flag 0,1 (IN,OUT)

here I'm Attaching a sample.

here I'm able to display the last login i.e. lets say an employee where there will be no access then on that day the entry will not be avail so

emp masters is considered where all the emp names will be avail and associated to biometric data.

kakani87 · ‎2018-01-11

Sunny ... did i properly explained you about what i want.

sunny_talwar · ‎2018-01-11

I am still not sure I understand it completely... can you may be explain with example from your attached app?

kakani87 · ‎2018-01-12

Here as shown in image it is displaying the last login data of an employee for the month but what my requirement is to show list of all days an employee not accessed considered as absent i need to display them.

this is a bio metric data.

lets say for example an employee list of days absent to be displayed this way

EID Emname Dates(Absent in the month)

C000872 Ajith 16-12-2017

C000872 Ajith 20-12-2017

C000872 Ajith 31-12-2017

Below is only max date it is displaying.

sunny_talwar · ‎2018-01-12

So, okay... you want to show all the days an employee was absent... how do you identify absent employee??? InOut? or something else?