topic Re: QVD in QlikView

QVD

srinivasa1 — Tue, 25 Mar 2014 14:08:56 GMT

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

Re: QVD

Nicole-Smith — Tue, 25 Mar 2014 14:11:02 GMT

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

STORE YourTable INTO YourQVD.qvd (qvd);

ENDIF

Re: QVD

srinivasa1 — Tue, 25 Mar 2014 14:39:10 GMT

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

Re: QVD

its_anandrjs — Tue, 25 Mar 2014 14:44:48 GMT

Hi,

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

Hope this helps

Thanks & Reagrds

Re: QVD

rbecher — Tue, 25 Mar 2014 14:52:19 GMT

Maybe this helps:

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

STORE...

- Ralf

Re: QVD

Tue, 25 Mar 2014 14:55:48 GMT

Try some more easy ;

Why doesn't use the Qlikview Management Console ?

Re: QVD

its_anandrjs — Tue, 25 Mar 2014 15:02:34 GMT

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

Re: QVD

Nicole-Smith — Tue, 25 Mar 2014 15:46:26 GMT

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

Re: QVD

Tue, 25 Mar 2014 15:54:27 GMT

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.