topic qvw file; is cube or what ? in QlikView

qvw file; is cube or what ?

Tue, 03 Jul 2012 16:41:10 GMT

I wonder qvw file structure. what like is it ? May it be a cube ?

Re: qvw file; is cube or what ?

swuehl — Tue, 03 Jul 2012 17:33:55 GMT

A qvw file is essentially the file that describes your application, including the load script, the variables, all chart objects with their dimensions / expressions / settings. Not forgetting defined Macros.

By default, a qvw file also stores the data model and the contained data after a perfomed data load, but you can remove this from the qvw file when saving.

I believe the data part of the qvw is a compressed storage of the internal data model, and I believe it is not a cube.

For more information about the data model and internal data storage, please check the whitepapers available from the Qliktech Web site and from the document section here in the forum. Also these blogs might be useful:

http://qlikviewnotes.blogspot.com/2011/02/qvd-questions-and-answers.html
http://qlikviewnotes.blogspot.com/2011/03/qlikview-compression.html

Regards,

Stefan

Re: qvw file; is cube or what ?

hic — Tue, 03 Jul 2012 19:15:49 GMT

All that Stefan writes is correct.

The data model in a qvw file is relational and it is exactly what you see when you look at the table structure (ctrl-t).

In addition, every chart is a virtual cube. "Cube" in the sense that it is a matrix of numbers in exactly the same way as OLAP tools have cubes. But nothing is pre-calculated: no data is stored in it, so it is "virtual". It is defined through the formulae for its dimensions and measures and is completely calculated every time the user clicks, using the data in the relational model.

HIC

Re: qvw file; is cube or what ?

Tue, 16 Oct 2012 17:58:13 GMT

I am so sory for being very late to thank you becasue I was far away my office.

Re: qvw file; is cube or what ?

Tue, 16 Oct 2012 17:58:23 GMT

I am so sory for being very late to thank you becasue I was far away my office.

Re: qvw file; is cube or what ?

Tue, 16 Oct 2012 17:58:42 GMT

I am so sory for being very late to thank you becasue I was far away my office.

Re: qvw file; is cube or what ?

Tue, 16 Oct 2012 18:00:15 GMT

Thanks but I am so sory for being very late to thank you and Stefan; I was far away from my office.