topic how to create qvd file in QlikView

how to create qvd file

Thu, 17 Feb 2011 08:47:17 GMT

Can anyone tell me how to create a qvd file and load it into my QV file. I am using QV10.

If possible give me some example how to write qvd file and store into QV file. I am new to QV knowledge.

Thks

how to create qvd file

Thu, 17 Feb 2011 08:55:07 GMT

lookup help of qv, search store

how to create qvd file

Thu, 17 Feb 2011 08:57:29 GMT

store tablename into qvdfilename.qvd;

load * from qvdfilename.qvd(qvd);

how to create qvd file

Thu, 17 Feb 2011 09:02:07 GMT

Exmpl

Load

X,y,Z

From abc;

Store A into Path\ABC.qvd;

Regards--

Nayan

how to create qvd file

Thu, 17 Feb 2011 09:18:25 GMT

hi for creating qvd file wheather i need to write in a textfile and save it as test.qvd or else i need to write in the editscript tab .

how to create qvd file

Thu, 17 Feb 2011 11:50:46 GMT

You have to create .qvw file for makking QVD say "MakingTest.qvw" (New File)

Now, write Script like Load * and so on and make QVD using 'store' keyward

and it will create your qvd. Refer code given in previous post

Regards--

Nayan

how to create qvd file

Thu, 17 Feb 2011 15:56:56 GMT

Thanks for your replies

I got it now how to work on QVD files

how to create qvd file

Thu, 17 Feb 2011 17:16:28 GMT

Hi,

Please verify

Regards--

Nayan

AW:Re: how to create qvd file

brenner_martina — Thu, 17 Feb 2011 17:44:26 GMT

Hi,

the store-function works only in the script. For storing data from a chart into a qvd-file you have to use a macro like this, vTempFolder, vQVDName are variables, CH02 is the ID of a chart:

'QVD-Export
sub ExpQVD

set v = ActiveDocument.Variables("vTempFolder")
set v1 = v.GetContent

tempFolder = v1.String

set v = ActiveDocument.Variables("vQVDName")
set v1 = v.GetContent

QVDName = v1.String

QVDFile = tempFolder & "\" & QVDName & ".qvd"

set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportEx QVDFile, 4
End Sub

how to create qvd file

Mon, 18 Apr 2011 13:46:11 GMT

can u please explain it clearly.can u please exlain it with any example?

how to create qvd file

Mon, 18 Apr 2011 13:50:26 GMT

Hi,

Pls chk attached app.

Thanks & Regards

how to create qvd file

Tue, 19 Apr 2011 05:34:16 GMT

hi im very new to qlik view.im not able to understand it.can uplease tel me the process clearly.

i have country.csv file in D drive

in country.csv i have columnns like country,country code,city

now please tell me tha way how to create QVD file and how to load those country,country code,city into that qvd using script.

please give me clear example.because im very poor in this.but i have 4 years experience in cognos.please explain me.

thanks

vamsi

how to create qvd file

Tue, 19 Apr 2011 12:19:27 GMT

hi vamsi,

Creating a Qvd file is very simple just use the Store keyword, i will show you the example based on your columns

TestQVD:

Load country,

countrycode,

city;

SQL select country, countrycode, city FROM ;

//The below statement will create a QVD for current table i.e; TestQVD.

STORE TestQVD into LearnQVD.qvd;

//******************Loading QVD into Edit Script**********************

//How you can use your QVD in your Edit Script is as follows

Comment your current table and click on the Table File in the edit script, then you can select the LearnQvd from your system and click Finish.

Then your Qvd file will displayed in current cursor position for the current table.

Please reffer the material of Qlikview for better understanding on QVD's.

Best Regards

Venkat

how to create qvd file

Wed, 20 Apr 2011 15:20:21 GMT

How can i Create QVD File in QlikView Version 9.0

Re: how to create qvd file

Sat, 26 Jan 2013 07:49:00 GMT

Hope this helps

Re: how to create qvd file

Thu, 16 Jul 2015 05:07:01 GMT

Did you get your answer or still waiting ?