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,


      person_id not in $(IDEX)




      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.