Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
Partner
Partner

Qlikview QVW and QVD data storage

Dear experts,

I'm new in QlikView/Qlik Sense. So, I describe our scenario to find out the best practice.

We will use QlikView to create dashboards with tables and graphs. As data source we will simply use .CSV files. These .csv files will be updated  during the time (records can be added or modified). I noticed that there are two main types of file in QlikView (QVW and QVD). Based on our scenario I wanted to ask:

1- Which type of file  (QVW or QVD) can we use to achieve this goal? (considering .csv files that will be updated continuously)

2- From storage point of view, which is the difference between QVW and QVD.

Thank you very much,

Shayan

Tags (4)
2 Solutions

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Qlikview QVW and QVD data storage

QVW is the QlikView application. That is, it loads the data and displays sheets and charts.  QVDs are "QlikView Data Files".  QVDs are like csv files but in a proprietary format. 

So no, you cannot choose between QVW and QVD.  You must always create a QVW to have an application that users interact with.  That QVW can load it's data from csv, QVD or both. 

-Rob

Support
Support

Re: Qlikview QVW and QVD data storage

Using the CSV files as a data source is perfectly okay to do, but you may want to look into QVDs as your dataset grows.

Here is some more information on QVD files and what their purpose is.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
For more Qlik Knowledge content, check out our Support Knowledgebase
3 Replies
MVP & Luminary
MVP & Luminary

Re: Qlikview QVW and QVD data storage

QVW is the QlikView application. That is, it loads the data and displays sheets and charts.  QVDs are "QlikView Data Files".  QVDs are like csv files but in a proprietary format. 

So no, you cannot choose between QVW and QVD.  You must always create a QVW to have an application that users interact with.  That QVW can load it's data from csv, QVD or both. 

-Rob

Partner
Partner

Re: Qlikview QVW and QVD data storage

Hello Rob,

Thanks for the answer, now is clear for me.

So, if I understand well, we can have two possible ways:

  • Use CSV files as data source.
  • Use QVD as data source.

Which is the best way to adopt? As I said our csv files will be updated continuously and record may be added or updated.

Thanks

Shayan

 

Support
Support

Re: Qlikview QVW and QVD data storage

Using the CSV files as a data source is perfectly okay to do, but you may want to look into QVDs as your dataset grows.

Here is some more information on QVD files and what their purpose is.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
For more Qlik Knowledge content, check out our Support Knowledgebase