How to crate QVD in QDF model

[sivaboggarapu20]

Hi Team,

Can some one explain me how to create QVD in QDF model architecture?

Thanks

Siva

[aunahsan]

if by QDF you mean Quicken Data file, you would have to :

1. Export Quicken data file to Excel

2. Load data the data from excel to Qliksense/Qlikview

3. Use the Store command to store the data into a QVD.

Goodluck!

[sivaboggarapu20]

Hi Anu,

QDF Qlik Deployment Framework. I want to store table into QVD.

Thanks,

Siva

[sumanta12]

Hi Siva,

Check the methods given below:

Method: 1

How to copy the Quicken data into Excel:

1.    Go to the "Reports" menu in Quicken and run the report you wish to export to Excel. If needed, change the date range of the displayed data using the drop-down menu to access the information you need.

2.    Copy the data using the "Copy" button at the top of the report.

3.    Open MS Excel. Create a new spreadsheet by choosing "New" under the "File" menu.

4.    Go to the "Edit" menu and choose "Paste." The data you copied from your Quicken report should appear on the spreadsheet.

5.    Save the spreadsheet using the file name of your choice by clicking "Save" under the "File" menu.

Method: 2

How to Export Quicken report data to Excel:

1.       In Quicken, display the report you want to export.

2.       On the toolbar, click Export Data.

3.       Choose To Excel Compatible Format.

4.       In the File name field, enter a name for the file.

5.       Switch to Excel.

6.       Use Excel's Open command, and navigate to the file containing your report data

Load excel data into Qlikview or Qliksense and store them in QVD.

[sivaboggarapu20 · Accepted solution]

Hi,

I am looking for the answer like below in Qlik Deployment Framework to store QVD

However, I got the answer. Thanks for your prompt reply

STORE * FROM [2017 FB] INTO [$(vG.AppQVDPath)\1.Extract\2017FB.qvd];

Thanks,

Siva

[rubenmarin]

Hi Siva, if your question is solved, please check the correct/helpful answer (can be yours) to mark the question as solved.

In case this helps: QDF QlikView Development Guide

Qlik Deployment Framework