Issue with incremental load using variable

[#1]

Hi

I am trying to do incremental load with the following script. But gives the error message saying that "Field not found - <MaxYear>". As per me everything looks to be correct only. Can some please tell me whats wrong with this script.

ExistingTable:
LOAD Field1
     ,Field2
     ,Year
     Month
..\App\Existing.qvd (qvd);
Temp:
Load Max(Year) AS MaxYear,Max(Month) AS MaxMonth Resident ExistingTable;
Concatenate(ExistingTable)
LOAD Field1 
     ,Field2
     ,Year
     ,Month    
FROM
..\App\Data.xls
(ooxml, embedded labels, table is Sheet1)
Where Year > $(vMaxYear)
Where Month > $(vMaxMonth);

Thanks

Attitude

[#2]

Hi Koushik

Still I am little confused! Because any way "Temp" table will return only one row then what is the use Peek function to return the particular value from the first row? Why can't we use something like below?

vMaxYear = MaxYear
vMaxMonth = MaxMonth
vMaxYearMonth = MaxYearMonth

Please explain it for my better understanding!

Thanks

Attitude

[kaushiknsolanki]

Hi,

   Actually you need to tell qlikview that which value you want  and from which field of which table.

   You tried doing what you said, and you didnt succeed, try using peek. It will solve your problem.

Regards,

Kaushik Solanki