topic Need a function to filter the IDs in QlikView

Need a function to filter the IDs

Wed, 22 Feb 2012 05:58:21 GMT

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.

Need a function to filter the IDs

CELAMBARASAN — Wed, 22 Feb 2012 06:37:26 GMT

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

Need a function to filter the IDs

Wed, 22 Feb 2012 08:25:07 GMT

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

Need a function to filter the IDs

CELAMBARASAN — Wed, 22 Feb 2012 08:57:28 GMT

Hi,

I cann't open any mails in my company.

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

Celambarasan

Need a function to filter the IDs

Mon, 27 Feb 2012 05:17:02 GMT

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.