Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharth_s3
Partner - Creator II
Partner - Creator II

Load variable in qvx load

Hi,

The below format does not work. Any idea why?

LET xVar = 'lib://SP2 (auspwicsbiweb01_administrator)/data?connectorID=Office365Connector&table=ListItemsFromID&subSite=%2fsites%2fSRVS-ICS-UNIX%2fics_analytics&listId=ca7912a5-ac72-4aa6-be80-eb50eb486beb&appID=';

LOAD

    Priority as ListItemsFromID_Priority,

    QlikPriority as ListItemsFromID_QlikPriority

FROM

[$(xVar)] (qvx);


I have created a connection in lib with SP2 as follows:

http://localhost:5555/

I have the Qlik Web connector running on port 5555

Basically, if I save the lib connection as follows and try, it works. Does not work with the variable in place.

http://localhost:5555//data?connectorID=Office365Connector&table=ListItemsFromID&subSite=%2fsites%2fSRVS-ICS-UNIX%2fics_analytics&listId=ca7912a5-ac72-4aa6-be80-eb50eb486beb&appID=';
2 Replies
siddharth_s3
Partner - Creator II
Partner - Creator II
Author

bump

siddharth_s3
Partner - Creator II
Partner - Creator II
Author

Anyone?