Discussion Board for collaboration related to QlikView App Development.
I have a question with functionality follow with QVD along with merge / concatenate. This question might be similar to previous question Q5 posted by me.
Take an example I have dimdate table , where my table contain records of 5 year (2011-2015). I write a query to load the dimdate in qvd file with concatenate.
LET lastReloadTime = Today();
If qvdcreatetime("Z:\Qlikview\Apps\TEHPRDT.qvd") Then
SQL SELECT "dimdate", "dimtime"
where dimdate >= '2015-01-01';
WHERE (dimdate > $(lastReloadTime));
Store dimQVD into Path\dimQVD.qvd;
In the above example I am trying to load data in qvd only for 1 year of period.
When I click on RELOAD my execution script says
dimQVD << dimdate 365 lines fetched
dimQVD << dimdate 456 lines fetched (still working.. not sure on this count)
Can any one guide me on this, why is the count difference ?
Perhaps the date format is not matching in the where clause for the last one with variable. Try like:
LET lastReloadTime = Date(Today(), 'YYYY-MM-DD');
WHERE (dimdate > '$(lastReloadTime)'); // single quotes around the variable expansion
Done the respective change, but makes no different
Anyone on this ?