topic Re: Extract data from data source to create .qvd. in QlikView

Extract data from data source to create .qvd.

Mon, 28 Apr 2014 11:39:25 GMT

Hi.... i am new to qlickview and i want to know that how to extract data from different data sources like excel or data base to create qvd....???

thank you.

Re: Extract data from data source to create .qvd.

tresB — Mon, 28 Apr 2014 11:44:34 GMT

Start reading pg no. 167(part 4: Script) onwards of the attached manual.

Re: Extract data from data source to create .qvd.

MK_QSL — Mon, 28 Apr 2014 11:46:10 GMT

Create a New QVW file

Go to Edit Script by Ctrl + E

Click on Table Files (at the Bottom)

Select Excel File

To Create a QVD

Store TableName Into 'QVDName.qvd' (QVD);

Re: Extract data from data source to create .qvd.

rustyfishbones — Mon, 28 Apr 2014 11:51:20 GMT

Load your table and then use STORE like below image

Re: Extract data from data source to create .qvd.

Mon, 28 Apr 2014 12:09:17 GMT

But i am working on server n my excel file is on local machine then how to

load data from local machine to server....bc oz i don't have 32 bit

qlickview connector.....

Regards

VINAY SINGH

IT (WWIL)

Re: Extract data from data source to create .qvd.

Mon, 18 Aug 2014 09:14:57 GMT

Vinay,

You don't have to have the Qlikview Connector to load the Excel on the Server. Just as you open the Excel File from your local machine, look out for the excel file located on the Server. Ensure that your computer is mapped to the folder on the Server where the excel is located.

Regs

Ram