2 Replies Latest reply: Jul 3, 2018 9:25 AM by Siddharth Sheshadri RSS

    Load variable in qvx load

    Siddharth Sheshadri

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