4 Replies Latest reply: Feb 27, 2012 12:17 AM by Gerard Carvalho RSS

    Need a function to filter the IDs

      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.