Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

26 Replies
kakani87
Specialist
Specialist
Author

Dear Tresesco,

This is Exactly the Result what i want but .... when i add this listbox in my dashboard attached in this post it is not working as same as the sample data.

This attachement shows the tran_date and a table with EmpId filter as few are not associated with that date, this people not associated to this selection list should be displayed As you shown me

Could you kindly Help me by looking into the dashboard attached in the first post

Regards,

Sai.

tresesco
MVP
MVP

This?

=Aggr(If(len(Concat(trim(tran_date)))=0,EmpName), EmpName)

If you prefer set analysis:

=Aggr(Only({<EmpName={"=len(Concat(trim(tran_date)))=0"}>}EmpName), EmpName)

kakani87
Specialist
Specialist
Author

No Tresesco ... On a particular day it should display the names.

lets say on 2nd of nov some 'N' people they are not in office now these people names to be displayed as Absent

On dynamically selecting the date filter no list of names it is displaying.

tresesco
MVP
MVP

May be combining these two expressions with an if like:

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

Aggr(If(len(Concat(trim(tran_date)))=0,EmpName), EmpName)

)

kakani87
Specialist
Specialist
Author

Hi Tresesco ... Thank you for spending your valuable time for helping me.

Requested My HR department for list of people to tally the output, so will  update you once i receive the list.

Regards,

Sai.


kakani87
Specialist
Specialist
Author

Hi Tresesco,

this expression is displayed in list box but the same in a table is no showing the data

Requirement is list of people absent  as on or max date with out any selection.

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

Aggr(If(len(Concat(trim(tran_date)))=0,EmpName), EmpName)

)

tresesco
MVP
MVP

In a table? How would that look like? Could you create a table and share and explain the expected output?

kakani87
Specialist
Specialist
Author

Actually this is a biometric data associated with employee masters.

Now show the list of absent people like

Empid | EmpName | last sign In date

Here we want to ignore people who are not active from a month i.e no entries signin and signout people should not  consider in absentees list.

PFA.

tresesco
MVP
MVP

So, you want a list of empnames who were not present on max date and were present in at least one day in last 30 days. Is my understanding correct?

kakani87
Specialist
Specialist
Author

List of absent people should be able to show on selection of date if no date got selected this should show today's list of people by default.