QVD

[srinivasa1]

Hi

How to store qvd on only on Monday of week. (how i can write ETl script for store QVD on Monday of week)

Pl guide me best way to achieve this.

Thx

[Nicole-Smith]

IF WeekDay(today()) = 'Mon' THEN

     STORE YourTable INTO YourQVD.qvd (qvd);

ENDIF

[srinivasa1]

Its not wokring for me WeekDay(today())  do you tink do i need to use pick funcation for retrive week day?

[its_anandrjs]

Hi,

Why not you schedule your reload time on every Monday and create those QVD.

Hope this helps

Thanks & Reagrds

[rbecher]

Maybe this helps:

IF Num(WeekDay(Today())) = 0 THEN

  STORE...

- Ralf

[#6]

Try some more easy ;

Why doesn't use the Qlikview Management Console ?

[its_anandrjs]

Hi,

If QEMC is not available you can do this way also

You can load this way also

LET vWeekday =WeekDay(Today());

IF $(vWeekday) = 'Tue' then

Temp1:

Load *,

Resident Temp;

STORE Temp1 INTO Temp1.qvd (qvd);

ENDIF

Hope this helps

Thanks & Reagrds

[Nicole-Smith]

It's working for me.  Are you sure you have the IF and THEN on the same line?

[#9]

Produce the QVD from a "QVD Loader" qvw that runs only on a Monday - scheduled via the QMC.

I do this weekly for a couple of storage apps I run.