Discussion Board for collaboration related to QlikView App Development.
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.
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!
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.
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!