6 Replies Latest reply: Jul 15, 2016 5:58 AM by Onno van Knotsenburg RSS

    Pre-Define Dimesion Group Settings within Load Script?

    Heinrich Badenhorst

      Hi Qlikkies,

       

      Just a general inquiry from my side.

       

      Is it possible to Pre-Define Dimesion Group Settings within Load Script?

       

      To illustrate:

       

      We have an IF statement in the load script defining alot of settings based on different initial values.

       

      We have 2 entities with different Year measurements one being a calendar year and the other financial year for example.

       

      We use this as a "Time" group in a dimension.

       

      Therefore:

       

       

      IF '$(vName)' = 'pse' THEN
      let vFolderSourceData = 'C:\QlikView\Data FilesPSEMAS\';
      let vStartPer = '01/04/2012';
      let vStart = '201204';
      let vEndPer = '30/06/2016';
      let vEnd = '201606';
      let vSchemePeriod = '0006201204';
      let vCalendarYear = '=FinYearPsemas' ;
      ELSE
      let vFolderSourceData = 'C:\QlikView\Data Files\';
      let vStartPer = '01/01/2012';
      let vStart = '201201';
      let vEndPer = '30/06/2016';
      let vEnd = '201606';
      let vSchemePeriod = '0001201201';
      let vCalendarYear = '=Year' ;
      END IF  

       

      ============================================================================================

      So what i want to know is how to in the script above achieve the changes shown below:

       

      IF '$(vName)' = 'pse' THEN

      image1.png

      ELSE

      image2.png

      END IF  

       

       

      Your soonest replies would be greatly appreciated.

       

      Thank you!