Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

qvw file; is cube or what ?

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

6 Replies
swuehl
MVP
MVP

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

hic
Former Employee
Former Employee

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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