topic Re: Cannot open file: *.qvd in QlikView

Cannot open file: *.qvd

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 18 Jan 2018 17:47:07 GMT

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 — Thu, 18 Jan 2018 18:32:20 GMT

You need to Store It