Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Can some one explain me how to create QVD in QDF model architecture?
Thanks
Siva
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
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!
Hi Anu,
QDF Qlik Deployment Framework. I want to store table into QVD.
Thanks,
Siva
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.
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
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