Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
Highlighted
deepakk
Valued Contributor III

Re: how to set a variable during reloading data

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

Re: how to set a variable during reloading data

Thank you

It works perfectly !!!!

deepakk
Valued Contributor III

Re: how to set a variable during reloading data

hi sharon,

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

Deepak

Not applicable

Re: how to set a variable during reloading data

hi

i am new here how do i do that?

deepakk
Valued Contributor III

Re: how to set a variable during reloading data

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

Re: how to set a variable during reloading data

thank you