Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

what is intermediate qvd? where we use this ?

what is intermediate qvd? where we use this ?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Extract data from database into intermediate qvd

Load data from intermediate qvd , transform data and store into final qvd

Load data from final qvd into dashboard qvw

View solution in original post

7 Replies
sebastiandperei
Specialist
Specialist

In Qlikview, you can store a table in a .qvd file.

You can use an application (commonly called "DATA_name.qvw") who reads the database and store each table in qvd files. So, another application could proccess it, like creating linking tables and make corrections in string fields... And again, stores the new tables in another qvd files... Finally, the end user application only reads this qvd's...

I dont know how are you using Qlikview, but it is the best way to work. If you read the database each time for every application you have, you are losing one of the most better part of Qlikview!!

Anonymous
Not applicable
Author

hello mr.

i know use of qvd's

read the question carefully

i raised a question what is intermediate qvd?

richard_chilvers
Specialist
Specialist

It is as Sebastian has said.

For example, I have a large database of customer details. I recreate this overnight into a QVD file (which is over 100MB itself) so that I can use it with my other QVW models, where it then loads supertfast.

It is 'internediate' because its between the raw database and the model itself.

Anonymous
Not applicable
Author

Hi,

Can you please let me know where you came  across this term 'Intermediate QVDs' ? I have so far heard only about QVDs

Anonymous
Not applicable
Author

Extract data from database into intermediate qvd

Load data from intermediate qvd , transform data and store into final qvd

Load data from final qvd into dashboard qvw

ThornOfCrowns
Specialist II
Specialist II

What do you understand an 'intermediate' QVD to be, other that what has been explained in the answers given?

Anonymous
Not applicable
Author

So here these are baically normal qvds  that are used as intermediate staging files...it is not a special file type as I understod form the question...correct me if there is any gap in my understanding