Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks Celambarasan. Can i have your mail id for future reference.
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
Thanks Celambarasan. Can i have your mail id for future reference.
Hi,
I cann't open any mails in my company.
Anyway my mail id is celambarasan.a@gmail.com
Celambarasan
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.