Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Naps_230
Creator
Creator

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.