Need a function to filter the IDs

[#1]

Hi i am a new to qlik view and i need a help!!!

I have created a variable IDEX which will hold certain ids in the format 'a234sd','a231sf','a233se',......... . i need to use this variable in all the table(example : 5 tables). i need to use the variable as a filter to exclude the ids,

Table1:

person_id not in $(IDEX)

Table2:

Empl_Id not in $(IDEX)

But the above query is not working, i am getting a error in script while reloding "Garbage after statement".

I need a function to be used to filter the ids.... I need to exclude all ids inside the variable when compared with the other fields of table.

[CELAMBARASAN]

Hi,

     Try with this

     Table1:

     Load

          person_id

     From..

     Where not match(person_id,$(IDEX));

     Table2:

     Load

          Empl_Id

     From..

     Where not match(Empl_Id,$(IDEX));

Hope it helps

Celambarasan

[#3 · Accepted solution]

Thanks Celambarasan. Can i have your mail id for future reference.

[CELAMBARASAN]

Hi,

     I cann't open any mails in my company.

     Anyway my mail id is celambarasan.a@gmail.com

Celambarasan

[#5]

I need a vairiable to assign the below scenario

To find out number of reports accessed in a month.... For example: some reports may be accessed for 2 or 3 or 6 months and some many not be accessed for any month.... So vaiable should be dynamic.