Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sushil353
Honored Contributor II

regarding data reloading

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

Tags (3)
5 Replies
Not applicable

regarding data reloading

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.

sushil353
Honored Contributor II

regarding data reloading

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

suniljain
Honored Contributor

regarding data reloading

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

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

Not applicable

regarding data reloading

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,

     B,

     C,

     ....

file1.qvd

(qvd);

Load A,

     B,

     C,

     ....

file2.qvd

(qvd);

and so on.

You can use the wizard for importing qvd files

Re: regarding data reloading

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

Community Browser