Discussion Board for collaboration related to QlikView App Development.
Is in possible to create a new QVD every Monday?
(There is a column in data source with only Monday's date for whole week)
May be try this?
ODBC CONNECT32 YourSourceDBName;
SQL SELECT ModifiedDate
LET vMondayDate = Peek('ModifiedDate',0,'MondayDate');
DROP TABLE Table1;
IF(ModifiedDate = Today() ) Then
SQL SELECT *
STORE Test INTO $(vQVDPath)Test.qvd (qvd);
DROP TABLE Test;
Store FirstTable INTO $(vQVDPath)DailyQvd.qvd(qvd);
Drop Table FirstTable;
View solution in original post
What is the date format of that DateField coming from Source?
Have not tested but
May be you can try like:
DROP TABLE MondayDate;
IF(ModifiedDate = Today()) Then
Parallel I would like to refresh data every day ? but would like to create a new qvd on Monday because my source will be wiped out previous week data on Sunday night
Simple words I need history on Monday for previous week and create and refresh new qvd for rest of present week
date in the format m/d/yyyy
When your source wipes out sunday night how can you get the Monday dates from your source for previous week?