Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

userid128223
Contributor

how to setup daily update of qvd

Hi Everyone

This is kind of best practice question and please give example.

If you have process running on server that generates new qvd and then another one that actually takes that newly generated qvd and merges with exisitng qvd.

1) how do you setup code to do auto update everyday.

2) I know the part on how to schedule 2 qvw to run on qmc task manager.

Please share an example

thanks

3 Replies
gupta_n8
Valued Contributor II

Re: how to setup daily update of qvd

This is a concept of incremental load.

Example >>

Daily_new:

Load * from <Table>

where date(update_date) >= date(today()-1)   ;                  // Any condition which is used to generate new qvd daily.

Store Daily_new into Daily_new.qvd;

drop table Daily_new;

Original:

Load * from original.qvd(qvd);

concatenate

Load * from Daily_new.qvd(qvd) ;

Store Original into Original.qvd;

In this way you can actually merge your new data to the previous one, and hence no multiple qvws will be required.

Hope this helps.

Regards

Nitin

userid128223
Contributor

Re: how to setup daily update of qvd

Thanks Nitin

How do you create data part automatically for each day so that you don't have to manage it.

gupta_n8
Valued Contributor II

Re: how to setup daily update of qvd

Can you please provide you script ,

so that I can explain it to you in a much better way.