Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharth_s3
Contributor

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
Contributor

Re: Load variable in qvx load

bump

siddharth_s3
Contributor

Re: Load variable in qvx load

Anyone?

Community Browser