Cannot open file: *.qvd

[Anonymous]

I am new to qlikview and i am not able to open the qvd file in the qvw file.

Here is the code which i used in the script of qvd

ODBC CONNECT TO [DOPAG;DBQ=DOPAG];

LOAD *; SQL SELECT * FROM IFSAPP.USER_FINANCE;

I am getting the message as 500 rows fetched

When i am trying to use the qvd file in qvw i am getting error file not found but the user_finance.qvd is present in the location.

USER_FINANCE: LOAD USERID, COMPANY AS COMPANY_ID, DEFAULT_COMPANY FROM D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd (qvd)

Error Message :

File not found error

Cannot open file: 'D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd'

[rubenmarin]

Hi Surendar, the qvd already exists. 'STORE' is used to create qvds, ie:

ODBC CONNECT TO [DOPAG;DBQ=DOPAG];

TableName:

LOAD *; SQL SELECT * FROM IFSAPP.USER_FINANCE;

STORE TableName  into [D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd] (qvd);

// This will overwrite the qvd. Chek if already exist before overwriting!

NoConcatenate // to avoid autoconcatenation with last table

USER_FINANCE: LOAD USERID, COMPANY AS COMPANY_ID, DEFAULT_COMPANY FROM D:\IFS\Qlikview\Data\Extracted\01_VIEWS\USER_FINANCE.qvd (qvd)

DROP Table TableName;

[zebhashmi]

You need to Store It