Discussion Board for collaboration related to QlikView App Development.
i create a variable (v_max_date) . the purpose of this is to hold the max date of the current table,
since i did an incremental load , i need this variable for the WHERE close.
i was thinking that every time the table is finish loading to Resident the table like this:
MaxString (Date) as maxdate
Now i want to make a variable to hold this maxdate for next time using.
how do i do it ?
try this out.
Let v_max_date = peek('maxdate');
I hope this helps.
It works perfectly !!!!
doo verify the post , it helps other to know that the issue has been resolved.
i am new here how do i do that?
On every post , you will see two button , one for correct answer and another one helpful.
If you get a correct answer, click that button. But sometimes you get some helpful answer too in that case click the other one.