Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: how to show unmarked people

May be use a set analysis like this:

{1<Date = e(Date)>}

Highlighted
Partner
Partner

Re: how to show unmarked people

Hi Tom,

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

we must exclude clients

Aiolos Zhao

Highlighted
Partner
Partner

Re: how to show unmarked people

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

Highlighted

Re: how to show unmarked people

Highlighted

Re: how to show unmarked people

Here is a sample

Capture.PNG

Highlighted
Not applicable

Re: how to show unmarked people

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

Highlighted
Partner
Partner

Re: how to show unmarked people

Hi Sunny,

Thanks for your reply, now I got it!

Aiolos Zhao

Highlighted
Partner
Partner

Re: how to show unmarked people

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