topic Re: how to set a variable during reloading data in QlikView

how to set a variable during reloading data

Thu, 20 Sep 2012 05:19:43 GMT

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

deepakk — Thu, 20 Sep 2012 06:02:12 GMT

hi Sharon,

try this out.

load

MaxString (Date) as maxdate

Resident Failures;

Let v_max_date = peek('maxdate');

I hope this helps.

Deepak

Thu, 20 Sep 2012 06:09:01 GMT

Thank you

It works perfectly !!!!

deepakk — Thu, 20 Sep 2012 06:17:15 GMT

hi sharon,

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

Deepak

Thu, 20 Sep 2012 06:35:59 GMT

i am new here how do i do that?

deepakk — Thu, 20 Sep 2012 06:40:12 GMT

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.

Thu, 20 Sep 2012 06:42:00 GMT

thank you