3 Replies Latest reply: Jul 11, 2014 6:09 AM by Alessandro Saccone RSS

    Add Code to Main Header Script

      Hello,

      It's possible to modifies the default script at the beginning? I'd like to add a part automatically every time I create a new QlikView document. Instead of:

       

      SET ThousandSep=' ';

      SET DecimalSep=',';

      SET MoneyThousandSep=' ';

      SET MoneyDecimalSep=',';

      SET MoneyFormat='# ##0,00 €;-# ##0,00 €';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

      SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';

      SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

       

      I'd like to have this:

       

      SET ThousandSep=' ';

      SET DecimalSep=',';

      SET MoneyThousandSep=' ';

      SET MoneyDecimalSep=',';

      SET MoneyFormat='# ##0,00 €;-# ##0,00 €';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

      SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';

      SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

       

      ///**********Adresses des tables**********///////

      VariablesAdres:

      LOAD

           Table_ID,

           Table_Adresse

      FROM

      [..\..\00 - Dico\Sortie\T_Dico_Adresse.qvd]

      (qvd);

       

      FOR vLineNo = 1 TO NoOfRows('VariablesAdres')

            Let Identifiant_Table = Peek('Table_ID',vLineNo-1,'VariablesAdres');

            Let $(Identifiant_Table) = Peek('Table_Adresse',vLineNo-1,'VariablesAdres');

      NEXT vLineNo;

       

      DROP TABLE VariablesAdres;

      ///*********Fin chargement adresses relatives*********////

       

      Thanks!!