3 Replies Latest reply: Jul 1, 2015 11:42 AM by Michael Tarallo RSS

    Qlik Sense LIB variable support

    Linda Bell

      Are variables supported in LIB URL definition in Sense version 2?

        • Re: Qlik Sense LIB variable support
          Michael Tarallo

          Hi Linda, it depends on how you want to use them.

           

          Do you want to use them in the connection name, or in the values used in an already defined connection?

           

          For example this is supported:

           

          let vRootPath = 'lib://QlikSenseDataFolder/';

          let vFileName = 'sample_data.qvd';

           

          let vFullFilePath = '$(vRootPath)$(vFileName)';

           

          trace This is the root path: $(vRootPath);

          trace This is the file name: $(vFileName);

           

          SampleTable:

          Load * Inline [

           

          id,department,budget,actual

          1,Sales,200000, 250000

          2,Human Resources,150000, 10000

          3,Finance,300000,250000

          4,IT,245000,100000

          ];

           

          Store SampleTable INTO '$(vFullFilePath)' (qvd);

           

          where QlikSenseDataFolder is already defined in the data connections.

           

          The actual Data Connection named needs to be defined.

           

          Please let me know more about your use case and I can provide more information if needed.

           

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

          Mike Tarallo

          Qlik