topic File path in QvdCreateTime in QlikView

File path in QvdCreateTime

Thu, 12 Mar 2015 05:40:38 GMT

Hi:

I was trying to use QvdCreateTime to check if a qvd file is exist or not.

At first, I was trying to use relative path in my script as followed (I already set my directory to a file called 'Data'. The qvd file sits in the 'QVD' file in side 'Data' file):

IF (NOT ISNULL(QvdCreateTime('QVD\MyQvdFile.qvd'))) THEN

//Do something

END IF

But the above code always skip.

Then I change it to a absolute path and it worked and the script inside get executed.

I want to ask how can I use the relative path in QvdCreateTime? Or it is default not to use relative path?

Thank you very much.

Best regards,

Paco

Re: File path in QvdCreateTime

senpradip007 — Thu, 12 Mar 2015 05:45:29 GMT

Try this....

IF (NOT ISNULL(QvdCreateTime('..\QVD\MyQvdFile.qvd'))) THEN

//Do something

END IF

Re: File path in QvdCreateTime

Thu, 12 Mar 2015 05:46:48 GMT

Hi Pradip:

Doesn't '..' take you to one level up in the directory?

Thanks.

Re: File path in QvdCreateTime

jonathandienst — Thu, 12 Mar 2015 06:07:47 GMT

Qvdxxx() functions can use certainly use relative paths. These are relative to the location of the qvw file. Unlike LOAD statements, they do not follow the DIRECTORY option, only the qvw document location.

HTH

Jonathan

Re: File path in QvdCreateTime

senpradip007 — Thu, 12 Mar 2015 06:10:54 GMT

Could you please tell me absolute path or folder structure of your project?

Re: File path in QvdCreateTime

Thu, 12 Mar 2015 06:31:37 GMT

Hi Jonathan:

I didn't know that DIRECTORY doesn't work on QvdCreateTime() functions.

Thank you very much.

Re: File path in QvdCreateTime

Thu, 12 Mar 2015 06:33:52 GMT

Hi Pradip:

Thank you very much for your reply.

As Jonathan suggested that, QvdCreateTime() functions does not follow the DIRECTORY options.

I think that's the reason why my script doesn't work.

Best regards,