topic Change load date in QlikView

Change load date

Mon, 03 Jan 2011 10:43:10 GMT

Hello!

I have a question aboat how i can change load date, i have a script i will load back in time with date as 2010-12-31, can i use "SET" in the beginnging of the scripr or?

I will load the script now but with the date 2010-12-31, do you understad me?

Somebody some have a idea?

Change load date

marcel_olmo — Mon, 03 Jan 2011 11:30:51 GMT

Hi popalm,

if what you want is to load an static date, yes, I'd load statically a variable with "2010-12-31".

I'm not pretty sure about what you want, maybe replace your reloadTime() function with this date¿?

Hope it helps!

Change load date

prieper — Mon, 03 Jan 2011 11:36:54 GMT

You may assign the required date to a variable and then refer to this variable in the script. Think that you should use LET rather than SET - the latter assigns a textstring (or a formula) to a variable, whereas LET assign values or results of an expression.

LET dStartDate = DATE#('12-31-2010', 'MM-DD-YYYY');
Table: LOAD * FROM .... WHERE MyDate >= $(dStartDate);

HTH
Peter

Change load date

Mon, 03 Jan 2011 11:39:23 GMT

I have tried but with no god result, i write SET date='2010-12-31'; in the begining of the script but it doesnt works, i se also data from 2011, i dont want that.

Can you help me with what should i write in the script

Change load date

Mon, 03 Jan 2011 11:43:13 GMT

i have many table to load, must i do this for every table?

Change load date

marcel_olmo — Mon, 03 Jan 2011 11:45:47 GMT

So what you want is to filter the loading data until "2010-12-31".

If I were you, I will try Peter's solution. You have to do a LET (evaluated variable) to set your "maximumLoadingDate", and then load the table in your script filtering by that date.

Cheers!