QVD

[#1]

Hi Everyone,

How to store data into QVD's Monthly wise.

Thanks

[settu_periasamy]

Hi,

Try this, You can just change your Date / Month Field

DIRECTORY ;
Test:
LOAD MonthName(Date) as MonthYear,*;
LOAD Date('1/1/2015'+IterNo()-1) as Date AutoGenerate 1 While IterNo()<=365;

Check:
Load Distinct Monthname(Date) as Month
Resident Test;

let vCount = NoOfRows('Check');

For i=0 to $(vCount) -1
Let vMonth = Peek('Month',$(i),'Month'); 
[$(vMonth)]:
Load *,'$(vMonth)' as Month1 Resident Test where MonthName(Date) = '$(vMonth)';
Store [$(vMonth)] into [$(vMonth)].qvd;
Drop table [$(vMonth)];  
NEXT

Drop table Check;

[settu_periasamy]

Hi,

Check these links too..

Create Monthly QVD's | Qlik Community

storing data into qvd in monthly basis | Qlik Community

[jagan]

Hi,

Check this link, hope it helps you.

storing data into qvd in monthly basis | Qlik Community

Regards,

Jagan.

[jagan · Accepted solution]

Once generating the QVD for past data by month, then you have to generate the latest QVD for the new months like below.

Data:

LOAD

*

FROM DataSource

WHERE MonthName(DateFieldName) = MonthName(Today());

LET vMonthname = MonthName(Today());

STORE Data INTO [DATA_$(vMonthname).qvd];

Hope this helps you

Regards,

Jagan.

[jagan]

You can load multiple QVDs using wildcard characters.  check below link

Loading Multiple QVD files

[avinashelite]

check this threads too

Create Monthly QVD's

Monthly Qvd

[Chanty4u]

chk dis too

QVDs creation?

[#9]

Thank You All