Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hello,

can someone explain:

" FROM

$(vFullQVDPath)\$(vFactQueryC7).qvd (qvd); "

Thanks in advance

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

Hi,

It is the load script part with variables

1. after From key word it is complete statement with file path and the file name in the variable.

FROM

$(vFullQVDPath)\$(vFactQueryC7).qvd (qvd); "

2. The variable $(vFullQVDPath)  caries QVD path

Ex:- D:\QVDFolder

Ex:- Let vFullQVDPath = 'D:\QVDFolder\';

3. The variable $(vFactQueryC7). caries Table name

Ex:- SalesFact.qvd

Ex:- Let vFactQueryC7 = 'SalesFact';


Hope this helps

Regards

Anand


View solution in original post

2 Replies
its_anandrjs
Champion III
Champion III

Hi,

It is the load script part with variables

1. after From key word it is complete statement with file path and the file name in the variable.

FROM

$(vFullQVDPath)\$(vFactQueryC7).qvd (qvd); "

2. The variable $(vFullQVDPath)  caries QVD path

Ex:- D:\QVDFolder

Ex:- Let vFullQVDPath = 'D:\QVDFolder\';

3. The variable $(vFactQueryC7). caries Table name

Ex:- SalesFact.qvd

Ex:- Let vFactQueryC7 = 'SalesFact';


Hope this helps

Regards

Anand


Anonymous
Not applicable
Author

Hi,

Which say that we are taking the QVD from a particular location..

Instead of loading all the path ,we save the path a variable and load it directly.