Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Naps_230
Contributor III
Contributor III

How to create Year Month wise Qvd dynamically

Hi,

I have requirement to create year wise qvd dynamically.

EX:-if Source file:-  Market.xls

In Market file have contain multiple year (Like year field contain 2010 to 2019 )

So i need to create qvd like :- Market_2010_Jan.qvd,...Market_2011.qvd_Jan,....Market_2019_Dec.qvd

2 Replies
Vegar
MVP
MVP

Exceldata:

Load 

Date(monthname(Date), 'YYYY_MM') AS Period

Date,

Field,

Value 

From excel.xlsx;

For each _period in fieldvaluelist('Period')

SingleMonthData:

NoConcatenate Load Date, Field, Value

Resident ExcelData 

Where Period = $(_period);

 

Store SingleMonthData into Marked_$(_period).QVC (qvd);

Drop table SingleMonthData;

Next

Brett_Bleess
Former Employee
Former Employee

See duplicate post for solution: https://community.qlik.com/t5/New-to-QlikView/How-to-create-Year-wise-Qvd-dynamically/m-p/1637440#M3...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.