Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to set a variable during reloading data

hi

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:

(

load

MaxString (Date) as maxdate

Resident Failures; 

)

Now i want to make a variable to hold this maxdate for next time using.

how do i do it ?

thank you

6 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi Sharon,

try this out.

load

MaxString (Date) as maxdate

Resident Failures;


Let v_max_date = peek('maxdate');

I hope this helps.

Deepak

Not applicable
Author

Thank you

It works perfectly !!!!

deepakk
Partner - Specialist III
Partner - Specialist III

hi sharon,

doo verify the post , it helps other to know that the issue has been resolved.

Deepak

Not applicable
Author

hi

i am new here how do i do that?

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

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.

Not applicable
Author

thank you