topic Re: Daily Qvd's in QlikView

Daily Qvd's

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

How to create Daily Qvd's? and how to generate qvd daily base contentiously?

Re: Daily Qvd's

Gysbert_Wassenaar — Tue, 03 May 2016 12:27:25 GMT

Each day load only the records of the last day and store the resulting table in a new qvd file.

DailyRecords:

LOAD

Field1,

Field2,

...etc

MyDate

FROM

MySourceTable

WHERE

MyDate = num(Today()-1)

;

LET vQVDName = 'DailyRecords' & Date(Today()-1,'YYYY-MM-DD')

STORE DailyRecords into $(vQVDName).qvd (qvd);

Re: Daily Qvd's

ramasaisaksoft — Tue, 03 May 2016 12:51:52 GMT

Hi Mahesh ,

What you are asking incremental load ?

or you want how many records are created newly today/update today?

https://www.resultdata.com/three-types-of-qlikview-incremental-loads/

Incremental Load in QlikView – Part2 – Learn QlikView

Re: Daily Qvd's

qlikview979 — Tue, 03 May 2016 16:58:06 GMT

Hi Gysbert Wassenaar,

where condition is not working and

You should change the Store command also

STORE "TABLE" DailyRecords into $(vQVDName).qvd (qvd);

after Store "TABLE" is not required.

Re: Daily Qvd's

qlikview979 — Tue, 03 May 2016 17:00:17 GMT

Hi Sai,

I Want to Generate Daily Qvd's Continuously?

Re: Daily Qvd's

qlikview979 — Tue, 03 May 2016 17:39:19 GMT

Hi Experts,

I want daily Qvd's on daily date base like this

01/05/2016

02/05/2016

03/05/2016

04/05/2016

05/05/2016

01/06/2016

etc.....

Re: Daily Qvd's

trdandamudi — Tue, 03 May 2016 17:51:29 GMT

Are you looking for something like below:

DailyRecords:

LOAD * inline [

Field1,Field2,Field3

A,F10,100

B,S20,200

C,T30,300

];

LET vQVDName = 'DailyRecords' & Date(Today(),'YYYY-MM-DD');

STORE DailyRecords into $(vQVDName).qvd (qvd);

The above script will create a .qvd file with a filename as "DailyRecords2016-05-03.qvd"

Re: Daily Qvd's

qlikview979 — Tue, 03 May 2016 17:51:48 GMT

Hi Experts,

I want daily Qvd's on daily date base like this

01/05/2016

02/05/2016

03/05/2016

04/05/2016

05/05/2016

01/06/2016

etc.....

Re: Daily Qvd's

trdandamudi — Tue, 03 May 2016 17:57:43 GMT

Or may be like this:

DailyRecords:

LOAD * inline [

Field1,Field2,Field3

A,F10,100

B,S20,200

C,T30,300

];

LET vQVDName = Date(Today(),'DD-MM-YYYY');

STORE DailyRecords into $(vQVDName).qvd (qvd);

The above script will create a .qvd file with filename as "03-05-2016.qvd".

Re: Daily Qvd's

qlikview979 — Tue, 03 May 2016 18:37:02 GMT

Hi Thirumala,

today date is 4/5/2016

i am not getting 4/5/2016.qvd;

please check once . if i go to next day i want current date qvd.

Regards,

Mahesh

Re: Daily Qvd's

trdandamudi — Tue, 03 May 2016 18:53:09 GMT

I am in US that is the reason you see the date as 3-5-2016. No issue I changed the code below and now you will see it as 04-05-2016.qvd.

DailyRecords:

LOAD * inline [

Field1,Field2,Field3

A,F10,100

B,S20,200

C,T30,300

];

LET vQVDName = Date(Today() + 1,'DD-MM-YYYY');

STORE DailyRecords into $(vQVDName).qvd (qvd);

Re: Daily Qvd's

qlikview979 — Wed, 04 May 2016 05:22:01 GMT

Hi Thirumala,

if i go for reload tomorrow can i get tomorrow qvd ?

Re: Daily Qvd's

qlikview979 — Wed, 04 May 2016 05:25:32 GMT

Hi Experts,

I have source1 folder Three Qvds names like

2016_01_01.qvd

2016_01_02.qvd

2016_01_03.qvd

qvd creation time is 11:10:10 AM

and

source2 folder Three Qvds names like

2016_01_01.qvd

2016_01_04.qvd

2016_01_05.qvd

Qvd creation time is 11:15:15 AM

then i have loaded all qvd's into qlikview .Check here 2016_01_01.qvd name having 2 qvd's ..

coming to my requirement

i need latest with same name 2016_01_01.qvd from source2

Output: i want 2016_01_01.qvd from source2 because this is the latest qvd based on timestamp.

Re: Daily Qvd's

Kushal_Chawda — Wed, 04 May 2016 05:58:06 GMT

see this

Creating Daywise QVDs

Re: Daily Qvd's

Anonymous — Wed, 04 May 2016 08:58:29 GMT

QVDs creation? | Qlik Community

it is use full to you