Load variable in qvx load

[siddharth_s3]

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=';

[siddharth_s3]

bump

[siddharth_s3]

Anyone?