Discussion Board for collaboration on QlikView Scripting.
How to use Exist function inside loop?
my question is when we do loop we cannot drop the table because i need to concatenate all things of loop together.
But i want exit function should work on each and every table created in the loop separately.
If you look at code below i cannot drop table hence exits function will not work for each table separately.
or j=2012 to 2012
for i=1 to 3
ID as ID1,
DATAAREAID1 as DATAAREAID,
where Year(MonthName)=$(j) and Month(MonthName)=$(i);
1 as ID1,
0 as EntryType,
4 as MetricID,
MonthName(Date('01/$(i)/$(j)')) as MonthName,
Upper(text(ID)) as DATAAREAID
// NAME as Company
where not Exists(DATAAREAID,ID) and [ISVIRTUAL]=0 and ID<>'0000';
The function exists() seems correct ... but you cannot use DATAAREAID in it (because QV does not know it yet, because you used AS) => you have to use upper(text(ID)) instead.