How to create monthly QVD ?

[#1]

I have a qvd file that i need to create from monthly qvd like " 201601.qvd "

How can i do this ?

[tamilarasu]

You can try like below,

Let vDate= Date(Today(),'YYYYMM');

MyQVD:

Load...

From qvd;

STORE MyQVD INTO $(vDate).qvd;

[sushil353]

let vYear = 2016;

let vMonth = 1;

for I=0 to 11

let vQVDFileName = $(vYear)&$(vMonth);

Store TableName into $(vQVDFileName).qvd(qvd);

next I ;

HTH

Sushil

[#4]

I need to create it from the Date Column in the Qvd file which is called Date.

[tamilarasu]

What is the date format for the column "Date".?

[#6]

Its numbers, but my TimeStampformat in the qvw is " YYYY-MM-DD "

[tamilarasu]

Could you share some example qvd.? It would be easy for me to help further.

[qlikview979]

Hi Akintosh,

I hope this is help full to you.

T1:

LOAD Date,

Day(Date) as Date1,

     Product,

      Sales

      FROM

(ooxml, embedded labels, table is Sheet1);

let Vm=NoOfRows('T1');

for i=0 to $(Vm)-1;

LET Vmonth=Month(Peek('Date',$(i),'T1'));

LET Vday=Peek('Date1',$(i),'T1');

STORE  T1 into D:\W-905\Personal\DAILY QVDS\Month\$(Vmonth).qvd (qvd);   

//////STORE  T1 into D:\W-905\Personal\DAILY QVDS\Month\New folder\$(Vmonth)_$(Vday).qvd (qvd); 

NEXT i;

Note:-  If you uncomment the  Second store command you will get Daily Qvd also.

Here My Date format is like  "MM/DD/YYYY". instead of my date format give your  date format.

Regards,

Mahesh

[#9]

And some other columns,

[#10]

Hello Mahesh, thank you for the answer.

The file source is a QVD file and has a Date,Year,Month and some other columns,

and the output should be YEARMONTH.qvd    for example:  201601.qvd