topic Using variables in file location/directory in QlikView

Using variables in file location/directory

Tue, 25 Nov 2014 14:29:35 GMT

Hi all,

I inherited a qvw that uses the variables below to get to file location:

let vData ='..\..\..\Data';

let vQVD = '..\Data';

Reading the variables on face value is straight forward but it seems files/qvd are not 'store in' the specified location above.

Please I will like to know whether there is anything I need to be aware of when using variables in file/folder location?

Regards,

Re: Using variables in file location/directory

Peter_Cammaert — Tue, 25 Nov 2014 16:03:05 GMT

This kind of path specification is always relative to the location of the QVW document (even when you INCLUDE this from a script file that resides in an entirely different location).

If you use a relative path like this in a LOAD statement, the path specification will be relative to the last DIRECTORY statement that immediately precedes the LOAD.