Regarding split qvd's monthly wise

d_koti24 — Thu, 25 Jun 2015 11:26:53 GMT

Hi All,

i have one qvd.that qvd contains 3 months of data.(ex:mainqvd contains apr,may,jun upto 24thdate 2015),i am getting the daily data from excel.

ex:

prev_usage:

Load

Dir,

date,

space

from

mainqvd.qvd(qvd) this qvd contains total data.

concatenate

curr_usage:

Load

Dir,

date,

space

from

Today.xlsx daily excel.

i am concatenating the daily curr_usage: data to prev_usage: now i dnt have any issue.but in future we will get more months of data.that will be added to mainqvd.qvd(qvd) .

that time it will take more time to load mainqvd.qvd(qvd) to concatenate the curr_usage: data.

Now My Requirement is

first i want to split that mainqvd.qvd(qvd) into monthly wise qvd's like apr.qvd,may.qvd,june.qvd.

but thing is june.qvd contains the data upto 24/06/2015 .now when 25/06/2015 data comes i want to add that 25/06/2015 data to june.qvd like this upto 30/06/2015

when 01/07/2015 data comes on that day i want create july.qvd and store the data into july.qvd,when 2/07/2015 data comes that data add to july.qvd like this upto 31/07/2015.when 1/08/2015 comes i want to create august.qvd

how to achive this?

help me on this...

regards,

Re: Regarding split qvd's monthly wise

d_koti24 — Thu, 25 Jun 2015 12:08:21 GMT

Any Idea?

Re: Regarding split qvd's monthly wise

Thu, 25 Jun 2015 13:06:01 GMT

Hi,

I believe if you use incremental load and then later you split data in monthly qvds, load time would come down considerably.

Regards,

Navdeep

Re: Regarding split qvd's monthly wise

Thu, 03 Sep 2015 13:33:43 GMT

Did you get the solution for it? if yes could you please share the same with us, I am also having the same problem. @d_koti24

topic Re: Regarding split qvd's monthly wise in QlikView

Regarding split qvd's monthly wise

Re: Regarding split qvd's monthly wise

Re: Regarding split qvd's monthly wise

Re: Regarding split qvd's monthly wise