topic Re: how to append and delete data in QVD in QlikView

how to append and delete data in QVD

Fri, 19 Apr 2013 10:42:32 GMT

i am loading daily data from Excel as today's date

Load

from

file

i want to save daily file in a qvd. So after a week , this qvd will have 7 days data

on the 8th day, i want to delete last 5 days data from the same qvd

please advise

thanks

Re: how to append and delete data in QVD

kaushiknsolanki — Fri, 19 Apr 2013 10:59:08 GMT

Hi,

Try something like this.

if day(today()) = 8 then

TB1:

Load * from abc.qvd where date >= today()-3;

Store TB1 into abc.qvd;

Else

Other script.

End if

Regards,

Kaushik Solanki

Re: how to append and delete data in QVD

Fri, 19 Apr 2013 11:11:24 GMT

thanks for that

but to append data in same qvd for multiple days, it is not working

for eg

day 1 i hit load button

Load

from file

store file into qvd

day 2 i hit load button

load

from file

store file into qvd

-----Day 1 data gets overwritten and i only see Day 2 data in qvd

any advise

thanks

Re: how to append and delete data in QVD

Fri, 19 Apr 2013 11:19:39 GMT

To append you need load the original QVD first, then concatenate the lastest data and store it into same QVD.

Ex:

LOAD * from Ex.qvd

concatenate

Load

from day2_data;

store Ex into Ex.qvd (QVd);

Hope this help.

Regards,

Amay

Re: how to append and delete data in QVD

kaushiknsolanki — Fri, 19 Apr 2013 11:20:48 GMT

Hi,

tell me what exactly you want to do after 7 days.

After 7 days you want only last 3 days data?

if not then kindly explain with example.

Regards,

Kaushik Solanki

Re: how to append and delete data in QVD

Fri, 19 Apr 2013 11:24:17 GMT

hey Amay and Kaushil

thats for your help

i will merge your solutions to get what i want

cheers