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: 
Not applicable

how to show unmarked people

hello.

i have a table of employees that contains their name,ID,Station and region.

what i enter some dates it shows me all the employees that are working on that dates.

what i need is the same table but with all the employees that are not working!!!!

i do not want to do"select excluded".

all i want is as soon as i select dates , i will have a table with all the employees that do not work on those dates

if its is not possible on qlikview, i will want you to show me the sql script that loads this information.

thanks

Tom Herman

8 Replies
sunny_talwar

May be use a set analysis like this:

{1<Date = e(Date)>}

uacg0009
Partner - Specialist
Partner - Specialist

Hi Tom,

I think what you want to ask is like this question :

we must exclude clients

Aiolos Zhao

uacg0009
Partner - Specialist
Partner - Specialist

Hi Sunny,

I saw some other answers that also use the e() function, but I didn't know how it worked.

Do you know any articles or could you please tell me when I need or can use e(), because I use HELP to check e(), it only shows about math, and I saw you or other people when you want to exclude some fields you use e().

Could you please how to use that function?

Thanks a lot!

Aiolos Zhao

sunny_talwar

Here is a sample

Capture.PNG

Not applicable
Author

Hi Tom,

Instead of using complex set analysis, You can create new column "IsWorkingFlag" in a script and mark "1" who has work for that date and "0" who was absent.

Regards

Nandkishor

uacg0009
Partner - Specialist
Partner - Specialist

Hi Sunny,

Thanks for your reply, now I got it!

Aiolos Zhao

uacg0009
Partner - Specialist
Partner - Specialist

Hi Kush,

Many thanks, now I remember this funciont - excluded function, actually when I see P(), I remembered that E().

Because I haven't use Qlikview around half year, so sometimes I don't remember the function meaning...

Anyway thanks a lot!

Aiolos Zhao