topic Re: Path as Variable in QlikView

Path as Variable

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I am using this statement to load data from a QVD.Is there any possibility to store the path:

c:\HummingBird\...............\Complex_QVD's\ in a variable and then call it in below statement?

Re: Path as Variable

Mon, 30 Sep 2013 11:42:14 GMT

HI Poornima,

Yes it is possible

use set function & Create Variable

Set Mypath=c:\HummingBird\...............\Complex_QVD's\

Then you can use

Load *

$(Mypath)FACT_WELLNESSMEMBERS.qvd;

Hope this is velpful for you

Re: Path as Variable

v_iyyappan — Mon, 30 Sep 2013 11:43:56 GMT

Set the QVD path like this

SET QvdPath = '..\QVDs\';

Test:

Load

From

$(QvdPath)Test.qvd

Note : you qvw file are in same location.

Regards,

Re: Path as Variable

vikasmahajan — Mon, 30 Sep 2013 11:45:53 GMT

STORE

DocumentPath() IN VARIABLE

vIKAS

Re: Path as Variable

Mon, 30 Sep 2013 12:04:20 GMT

SET vFolderSourceFile = 'C:\Hummingbird\CustomerReporting\0_QVD_Generators\Complex_QVDs\';

[Table1]:

LOAD ........

.......

FROM '$(vFolderSourceFile)FACT_WELLNESSMEMBERS.qvd'

Re: Path as Variable

Anonymous — Mon, 30 Sep 2013 12:08:40 GMT

Yes.

you can write before your load:

Set vPath="c:\HummingBird\...............\Complex_QVD's\ ";

and then replace:

FROM $(vPath)&yourfilename.qvd (qvd);

I hope to help you.

Regards

Re: Path as Variable

tresB — Mon, 30 Sep 2013 12:10:26 GMT

Try like:

SET QVPath=C:\Users\....\QV;

Load * From $(QVPath)\ABC.qvd(qvd);

Re: Path as Variable

Andrea_Ghirardello — Mon, 30 Sep 2013 12:13:38 GMT

set YourVariableName = 'C:\YourPath\';

Load

field1,

field2

from $(YourVariableName)YourQvd.qvd (qvd);