Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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