Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Q6. Concatenate in QVD

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

3 Replies
Highlighted
MVP
MVP

Re: Q6. Concatenate in QVD

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

Highlighted
Not applicable

Re: Q6. Concatenate in QVD

Done the respective change, but makes no different

Highlighted
Not applicable

Re: Q6. Concatenate in QVD

Anyone on this ?