Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data loading from QVD

Hello everyone,

So I'm starting to implement qvd in my qlikview application.

So far I have read some posts about how to use the qvds and I already created the files.

So far the script on my qvw has the following structure:

     SQL Connection String

     query1:

               Select statement;

               STORE query1 INTO query1.qvd(qvd);

     query2:

               Select statement;

               STORE query2 INTO query2.qvd(qvd);

     query3:

               Select statement;

               STORE query3 INTO query3.qvd(qvd);

The qvds are created with the data from the select statement. But I have some questions regarding this:

     - How do the qvds reload the information?

     - After the creation of the qvds, can I delete the select statement from the qvw?

     - Should I put the select statement in the qvd instead?

I'm a little confused regarding how everything should be connected in order to be efficient using the qvds.

Thank you in advance.

Ivo

15 Replies
ankit777
Specialist
Specialist

If all your tables have same columns and similar data u can concatenate it in one table and store in one qvd.

qlikmsg4u
Specialist
Specialist

QVD stores only one table, if you want to store more than one table then you need to concatenate those tables .

Please refer this link for more information on this topic

https://community.qlik.com/thread/28747

Not applicable
Author

I cannot find information about how to join the queries.

I made a little bit of research but everything I find is not exactly what I need.

My script has the following structure:

query1:

    Select statement;

query2:

    Select statement;

query3:

    Select statement;

query4:

    Select statement;

When the script reloads all the result are joined because I have the same ID in all the selects of the 4 queries.

My problem is how I can join everything in a general query to send to a QVD.

I was trying to do this:

GeneralQuery:

LOAD * RESIDENT query1; OUTER JOIN(GeneralQuery) LOAD * RESIDENT query2;

GeneralQuery:

LOAD * RESIDENT GeneralQuery; OUTER JOIN(GeneralQuery) LOAD * RESIDENT query3;

GeneralQuery:

LOAD * RESIDENT GeneralQuery; OUTER JOIN(GeneralQuery) LOAD * RESIDENT query4;

But my script returns a error of table not found (I think is because of the "GeneralQuery"), but I do not know how to solve it... Am I missing something in the script?

Thank you for the help.

Gysbert_Wassenaar

Perhaps one or more of the queryN tables is not created. If a table contains exactly the same fields as a table created earlier then the data is appended to that existing table instead of creating a new table.


talk is cheap, supply exceeds demand
bestofwest
Creator II
Creator II

"From what I understood I will always need a QVW to generate the QVD. "

INCORRECT

ankit777
Specialist
Specialist

What I mentioned was , if all your query return same columns then u can use concatenate statement to concatenate all query result into one table and then save as one QVD.

You are getting an error because while using resident load prefer adding NOCONCATENATE before the load statement(if columns are same, then QLikview autoconcats the tables)