topic Re: How Qlikview gets the data while re-opening an application? in QlikView

How Qlikview gets the data while re-opening an application?

Anonymous — Thu, 23 Jun 2016 04:13:59 GMT

Please help

Assume that I am using a QlikView desktop in my own PC and not using a QVD.

Lets say I created a simple QVW file(from a Data source) with one list box (with some country names) and a text box with an expression (Sum(sales) . With that work I have closed the document.

While re-opening the document, how the aggregation is done (in this case sum(sales) and the list box is populated?

I understand after re-opening the document, the data will be loaded in to the memory.

But how does qlikview gets the data while re-opening the document? Where the data will be stored when I close the document?

Thanks,

Karthick S

Re: How Qlikview gets the data while re-opening an application?

Peter_Cammaert — Thu, 23 Jun 2016 09:31:29 GMT

The associative database is integrated in your QVW (=QVW file contains everything; UI, script, entire DB with all data, variables, metadata etc...). As long as you don't refresh your internal data by running the included load script, your document will always show/aggregate the included data. If your document has no load script (a document distributed by the Publisher for example), no updates are possible.

Peter.

Re: How Qlikview gets the data while re-opening an application?

Anonymous — Thu, 23 Jun 2016 14:29:17 GMT

Thanks Peter.

But I did not understand from your explanation. Could you please explain in detail?

Re: How Qlikview gets the data while re-opening an application?

Peter_Cammaert — Thu, 23 Jun 2016 15:23:38 GMT

What part was it that you didn't understand?

Re: How Qlikview gets the data while re-opening an application?

Anonymous — Thu, 23 Jun 2016 15:44:22 GMT

you mean to say each qlikview document has its own associative database and that database stores all the information such as script, UI and aggregated results?

what about a qilkview documet that uses QVD file as an input?

Re: How Qlikview gets the data while re-opening an application?

awhitfield — Thu, 23 Jun 2016 15:52:48 GMT

the QVD is simply a data source to load from, one it's reload the data is stored within the QVW.

Andy

Re: How Qlikview gets the data while re-opening an application?

Anonymous — Thu, 23 Jun 2016 15:53:29 GMT

Example, if i use a qvd fiel as my input source then the data would be stored in the qvd file and while re-opening the document, the data from the qvd will be loaded in to qlikview memory and i get the desired result.

Whereas if i am not using qvd file then from which location the data would get loaded in to the qlikview memory?

As you said, if there is an associative database, then how that works for a qvd input qvw file vs non qvd input qvw file?

Re: How Qlikview gets the data while re-opening an application?

Anonymous — Thu, 23 Jun 2016 15:56:10 GMT

Andy, you mean to say that if load millions of data in a qvw file, then that millions of data will reside within that qvw file?

Re: How Qlikview gets the data while re-opening an application?

Peter_Cammaert — Thu, 23 Jun 2016 16:18:17 GMT

Yes, each QVW incorporates its own associative database, and aside from this associative database, a QVW also may or may not include a reload script and a user interface. But those two are not always included. For example, a document that is pushed to the AccessPoint by the full Publisher has no script, and a QVD generator document has no user interface because it doesn't need one.

Even worsev : an associative database doesn't exist outside of a QVW document. But that's not a problem at all!

Best,

Peter

Re: How Qlikview gets the data while re-opening an application?

Peter_Cammaert — Thu, 23 Jun 2016 16:27:43 GMT

Please do not reply to yourself. Reply to the person that you are talking to or nobody will know for sure who you're expecting a reply from.

As Andrew already explained, a QVD is a QlikView Data File that contains a single data table and nothing else.

A QVW document is also a single file but it contains an associative database (often referred to "a data model") and much, much more. A QVW document needs to contain some script code for the data to get refreshed. That script code (which may refer to other external script files if you wish) will get executed during every reload. The script code or the user interface or the macros you decide to write to do nifty things are NOT stored in the associative database, but right next to it in the QVW.

Peter

Re: How Qlikview gets the data while re-opening an application?

Digvijay_Singh — Thu, 23 Jun 2016 16:39:20 GMT

Once reload is finished, everything is stored in QVW itself.

A QlikView desktop client or Qlikview Server knows how to run QVW so that the application logic of QVW whether it is written to show dashboard etc can be met. It doesn't need QVD or anything else once reload is finished, as long as you don't want to add/update/delete the data you used while reloading.

Re: How Qlikview gets the data while re-opening an application?

Anonymous — Fri, 24 Jun 2016 03:42:05 GMT

Thanks Peter. I understand the concept now