Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Concatentate to QVD

Hi All,

Here is what I'm trying to do. I made a QVD with a single date and a count of reports. I then loaded that QVD back into my QVW and want to concatenate the current days date and report count to it. I do this every time the QVW is refreshed as long as the current date is different.

The way I have it set up below, it seems to be keeping the original row from when i made the QVD and then concatenates as it should. But every time it refreshes (once a day) it replaces the second row in the QVD with the current date and count, doesn't add a row. How can I get this to work correctly?


1 Reply
Not applicable

Re: Concatentate to QVD

Here's whats in the QVD...

Sample 2.png

It should have a new row for each day but it just replaces the second row with the current date and total count.

Any ideas?

Community Browser