topic regarding data reloading in QlikView

regarding data reloading

sushil353 — Wed, 25 May 2011 08:42:27 GMT

Hi experts,

suppose i have five tables to load in the application. Among the five table there is one table on which i want to aply incremental load..

Now i want such technique so that the rest four tables must be loaded for the first time load.. when i try to aply the incremental load on fifth table the rest four table should not load again and again...

How can i solve the above said problem..

Thanks in advance

regarding data reloading

Wed, 25 May 2011 08:58:32 GMT

Hi,

Create a script just for loading those four tables and store the resulting data in qvd files. Then, in another qvw document, load qvd data and create a query for updating only the fifth table.

regarding data reloading

sushil353 — Wed, 25 May 2011 09:15:35 GMT

Hi Medina,

How could we store the four table in qvd file as qvd file can only store single table..

And how can i used two or multiple qvd file in single application.

Thanks

regarding data reloading

suniljain — Wed, 25 May 2011 09:20:10 GMT

you can store single QVD of four different table by performing join operation.

you can use multiple QVD in single application by linking QVD.

regarding data reloading

Wed, 25 May 2011 09:20:34 GMT

Hi,

First create a qvw file, which will only read the four tables from database and store each one in a different qvd file.

Then, in another qvw file you have to read those qvd files in the way:

Load A,

....

file1.qvd

(qvd);

Load A,

....

file2.qvd

(qvd);

and so on.

You can use the wizard for importing qvd files

Re: regarding data reloading

kaushiknsolanki — Wed, 25 May 2011 10:10:55 GMT

Hi,

Create a varibale named "v". From Settings->Variable. set value 0.

Copy below Script to your script.

if $(v) = 0 then
LOAD * INLINE [
    Data, Min, Max
    A, 0, 10
    B, 1, 20
    C, 2, 30
    D, 3, 40
];
ELSE
LOAD * INLINE [
    Data1, Min1, Max1
    A, 0, 10
    B, 1, 20
    C, 2, 30
    D, 3, 40
];

let v = 1;
end if

Also have a look at the attachment.

Regards,

Kaushik Solanki