Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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