Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load from Windows' environment variables path?

Did some Googling but couldn't find this answer .. does anyone know if data sources can be referenced using Windows environment variables to define the path?  Eg  %HOMEPATH%  = \Documents and Settings\{username}


1 Solution

Accepted Solutions
rbecher
MVP
MVP

Hi,

I think it is not possible to use environment variables directly in the LOAD statement. But you can read a path from the registry:

let vPath=GetRegistryString('HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders','Personal');

LOAD *

FROM $(vPath)\test.qvd (qvd);

- Ralf

Vizlib Head of R&D

View solution in original post

2 Replies
rbecher
MVP
MVP

Hi,

I think it is not possible to use environment variables directly in the LOAD statement. But you can read a path from the registry:

let vPath=GetRegistryString('HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders','Personal');

LOAD *

FROM $(vPath)\test.qvd (qvd);

- Ralf

Vizlib Head of R&D
Not applicable
Author

Thanks Ralf that is as good as!