Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD

Hi Everyone,

How to store data into QVD's Monthly wise.

Thanks

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

8 Replies
settu_periasamy
Master III
Master III

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;

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this link, hope it helps you.

storing data into qvd in monthly basis | Qlik Community

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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
MVP
MVP

chk dis too

QVDs creation?

Not applicable
Author

Thank You All