topic Re: How to create QVDfile in qlikview? in QlikView

How to create QVDfile in qlikview?

Mon, 17 Mar 2014 11:33:44 GMT

hai guys

I have created Employees file in excel that excel file how to convert into qvd file in qlikview .please help me.

i attached snipping file below this box.

Re: How to create QVDfile in qlikview?

MK_QSL — Mon, 17 Mar 2014 11:36:50 GMT

Store YourTableName into 'C:\QlikView\\QVD\YourQVDName.qvd' (QVD);

Re: How to create QVDfile in qlikview?

Miguel_Angel_Baeyens — Mon, 17 Mar 2014 11:42:46 GMT

Hi,

Your script is OK, but you need to add (QVD) to the end of the STORE line:

STORE Table INTO File.qvd (qvd);

Miguel

Re: How to create QVDfile in qlikview?

Mon, 17 Mar 2014 11:57:46 GMT

Hello Madhu,

Your code looks fine to me, but have a space between INTO and [].

that should work.

Thanks & Regards,

Venkat T

Re: How to create QVDfile in qlikview?

its_anandrjs — Mon, 17 Mar 2014 12:02:07 GMT

Hi,

Write a code some thing like

let vSourceloc = 'c:\QVDData\';

Table1:

Load

Statement

from location

Store Table1 from $(vSourceloc)Table1.qvd;

Hope this helps

Thanks & Regards

Re: How to create QVDfile in qlikview?

manojkulkarni — Mon, 17 Mar 2014 12:06:59 GMT

You are missing semicolon in store statement. otherwise your script is correct.

Re: How to create QVDfile in qlikview?

senpradip007 — Mon, 17 Mar 2014 12:14:21 GMT

Hi Madhu.

In your uploaded picture you have missed semicolon(;).

you should go through QlikView Reference Mannual or take a look in QlikView Help.

Re: How to create QVDfile in qlikview?

ngulliver — Thu, 20 Mar 2014 14:30:55 GMT

Hi, Madhu.

Can I direct you towards a blog on this ?

www.quickintelligence.co.uk/qlikview-qvd-files/

Hope it helps,

Neil

Re: How to create QVDfile in qlikview?

Sun, 29 Jun 2014 04:12:06 GMT

Hi Madhu

Read the below blog it really helps to under stand the optimised QVD as well

Optimized and unoptimized QVD Load Situations?

Optimized and Non Optimized loading

Regards

Padma