Discussion Board for collaboration related to QlikView App Development.
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.
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.
Create a list box with the following expression:
=Aggr(Only({1<EmpName=E(EmpName)>}EmpName), EmpName)
There is nothing using EmpName in your Application?
Hi Tresesco,
Created A list box as you suggested, this is Displaying employees when we select the data dynamically
Hi Anil,
Why not EmpName And EmpId is available
What are you trying to have in List-box? May be this?
=Aggr(EmpName,EmpName)Re: list of Names having no entries
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
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
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
Like this?
=Aggr(Only({1<Emp_Name={"=Len(trim(Date))=0"}>}Emp_Name), Emp_Name)