Discussion board where members can get started with QlikView.
I have two tables in the data base
table1 and table2
table1 having total weeks data and table2 has only this week data [All columns are same ]
so now am doing the concatenation like below is it correct or wrong?
Store Table1 into [lib://QVD_DATA/MainTable.qvd];
Drop Table Table1;
Correct one only, Can you explain how you declare the vMaxWeek and which table field you used?
variable is below
and field used is table1
let vMaxWeek= Num(Peek('MaxWeek',0,'MaxWeek'))-1;
Yes approach is correct one only
Try this in where one of this check which is worked for you
where WeekNumber >= $(vMaxWeek);
where WeekNumber >= '$(vMaxWeek)';
//Here you use wrong table name concatenation you use Concatenate(tabl1) which is wrong.