1 Reply Latest reply: Aug 14, 2018 11:20 AM by Brunello Menicucci RSS

    Identify what environment we are

    Brunello Menicucci

      Hello qlikers,

      I've a quick question for you laid on the beach!

      I'm using my QDF scripts in both Qlik Sense and Qlik View. The question is: how do I know, from a script perspective, which environment I am dealing with? This can be useful, for instance, during an automated "LOAD" of QVDs: if you are in QS, to identify the path of the file you have to use "/" while in QV you have to use "\".

      Any idea?

      Thanks a lot and have a nice summer time!

      Brunello

        • Re: Identify what environment we are
          Brunello Menicucci

          This is my actual script: it looks like I'm able to make it work on QS or QV but not both!

           

          LET QVD = '$(vG.LoadPath)';

           

          // Generate the Loop for each value in the LIST_OF_TABLES table

          FOR EACH vFileName IN filelist(QVD& '\*.qvd')

           

          IF NOT ISNULL('$(vG.HomeContainer)') THEN

          LET vFileBaseName=replace(subfield('$(vFileName)', '/', -1), '.qvd', '');

          ELSE

            LET vFileBaseName=replace(subfield('$(vFileName)', '\', -1), '.qvd', '');

          ENDIF

           

          [$(vFileBaseName)]:      

          LOAD

            *

          FROM $(vFileName) (qvd);  

           

          next vFileName