Solved: list of Names having no entries - Qlik Community

kakani87 · ‎2017-12-14

Hi Folks ....

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

Can any one help me to acheive this

Regards,

Sai.

tresesco · ‎2018-01-04

May be like this?

=Max({<tran_date,EmpName=p({<tran_date={'>$(=num(Addmonths(today(),-1))) <$(=num(Today()))'}>})>* <tran_date,EmpName=e({<tran_date={'$(=If(getselectedcount(tran_date),Max(tran_date),today()))'}>})>}tran_date)

When you clear all and see, you might not see any employees, because you don't have data for Dec'17 data (today()- 1 month). You can replace highlighted -1 by -2 to see results for absentees who were at least present in last two months, or try on data where you have data of last months.

View solution in original post

tresesco · ‎2017-12-14

Create a list box with the following expression:

=Aggr(Only({1<EmpName=E(EmpName)>}EmpName), EmpName)

Anil_Babu_Samineni · ‎2017-12-14

There is nothing using EmpName in your Application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

kakani87 · ‎2017-12-14

Hi Tresesco,

Created A list box as you suggested, this is Displaying employees when we select the data dynamically

kakani87 · ‎2017-12-14

Hi Anil,

Why not EmpName And EmpId is available

Anil_Babu_Samineni · ‎2017-12-14

What are you trying to have in List-box? May be this?

=Aggr(EmpName,EmpName)Re: list of Names having no entries

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

kakani87 · ‎2017-12-14

Actually in the dashboard it is showing access details

I want the list of people absent on the date to be displayed

This is a requirement for attendance dashboard to track people attendance and this is a biometric data shows in and out details based on this we have to display

kakani87 · ‎2017-12-14

Anil I ll explain you what my approach is

Attendance to display people who are absent

So this is a biometric data where only people accessed will be available, but employee masters is associated to this data.

Now I should find the absent people based on the employee masters where all employees avail, now how to display that employees without any in and out access considered as absent

kakani87 · ‎2017-12-14

Hi Anil,

Here is a sample data, now i want to display the emp_id 3,5,8 as absent for the day in a chart as absent list.

Here no entries we can see but when it comes to my dashboard even this entries will not be available in chart

tresesco · ‎2017-12-15

Like this?

=Aggr(Only({1<Emp_Name={"=Len(trim(Date))=0"}>}Emp_Name), Emp_Name)