Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be use a set analysis like this:
{1<Date = e(Date)>}
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
Here is a sample
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
Hi Sunny,
Thanks for your reply, now I got it!
Aiolos Zhao
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