topic Re: expression for all date entries in QlikView

expression for all date entries

kakani87 — Thu, 11 Jan 2018 15:49:38 GMT

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.

Re: expression for all date entries

sunny_talwar — Thu, 11 Jan 2018 16:27:37 GMT

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

Re: expression for all date entries

kakani87 — Thu, 11 Jan 2018 16:33:14 GMT

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.

Re: expression for all date entries

kakani87 — Thu, 11 Jan 2018 16:48:13 GMT

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

Re: expression for all date entries

sunny_talwar — Fri, 12 Jan 2018 01:13:01 GMT

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

Re: expression for all date entries

kakani87 — Fri, 12 Jan 2018 05:07:47 GMT

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.

Re: expression for all date entries

sunny_talwar — Fri, 12 Jan 2018 09:03:59 GMT

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