Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND 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?