topic Re: what is intermediate qvd? where we use this ? in QlikView

what is intermediate qvd? where we use this ?

Anonymous — Thu, 29 Jan 2015 13:46:35 GMT

what is intermediate qvd? where we use this ?

Re: what is intermediate qvd? where we use this ?

sebastiandperei — Thu, 29 Jan 2015 13:52:26 GMT

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

Re: what is intermediate qvd? where we use this ?

Anonymous — Thu, 29 Jan 2015 14:05:21 GMT

hello mr.

i know use of qvd's

read the question carefully

i raised a question what is intermediate qvd?

Re: what is intermediate qvd? where we use this ?

richard_chilvers — Thu, 29 Jan 2015 14:07:38 GMT

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.

Re: what is intermediate qvd? where we use this ?

Anonymous — Thu, 29 Jan 2015 14:14:14 GMT

Hi,

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

Re: what is intermediate qvd? where we use this ?

Anonymous — Thu, 29 Jan 2015 14:20:46 GMT

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

Re: what is intermediate qvd? where we use this ?

ThornOfCrowns — Thu, 29 Jan 2015 14:22:10 GMT

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

Re: what is intermediate qvd? where we use this ?

Anonymous — Thu, 29 Jan 2015 14:44:46 GMT

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