topic Re: qvd in QlikView

qvd

Wed, 18 Jun 2014 09:25:59 GMT

My problem:

First of all i create a QVD of a table with the whole data.

I want to name the changed qvd Tablename -20140617

This qvd is genearted every day how can i create the name with the actual Date

Like Tablename -20140617

Tablename- 20140618

…..

The second problem is to create a new qvd with the old big data and the changed lines

There is a field who said me which line is changed…

How can i make it with a script in a qvw?

MK_QSL — Wed, 18 Jun 2014 09:29:48 GMT

Create a variable for date and add with QVD storing function...something like below

Let vDate = Date(Date#(Today(),'DD/MM/YYYY'),'DDMMYYYY');

Sales:

Load * Inline

[

Customer, Sales

A, 100

B, 120

];

Store Sales into Sales$(vDate).qvd(qvd);

For 2nd Question,, you need to use incremental load.. It's a big topic and you can search from Community...

Wed, 18 Jun 2014 09:30:49 GMT

Do one thing take a variable & set it to date format whatever you want, & when you are going to save qvd use that variable as qvd name...