Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master 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

5 Replies
Not applicable

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
Master II
Master II

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
Master
Master

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

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

kaushiknsolanki
MVP & Luminary
MVP & Luminary

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".