This content has been marked as final. Show 4 replies
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.