Community,
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
dimQVD:
SQL SELECT "dimdate", "dimtime"
FROM "dimdate"
where dimdate >= '2015-01-01';
ELSE
dimQVD:
SQL SELECT "dimdate", "dimtime"
FROM "dimdate"
where dimdate >= '2015-01-01';
END IF
Concatenate (dimQVD)
SQL SELECT
"dimdate", "dimtime"
FROM "dimdate"
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 ?
Cheers
Varun
