Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

list of Names having no entries

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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.

Capture.JPG

View solution in original post

26 Replies
tresesco
MVP
MVP

Create a list box with the following expression:

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

Anil_Babu_Samineni

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
Specialist
Specialist
Author

Hi Tresesco,

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

kakani87
Specialist
Specialist
Author

Hi Anil,

Why not EmpName And EmpId is available

Anil_Babu_Samineni

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

=Aggr(EmpName,EmpName)

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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

Like this?

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