Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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!!

1 Solution

Accepted Solutions

Re: Add Code to Main Header Script

Create the script, save it in a txt file then at the top of your document insert it with an include statement (look in in the help) and finally delete the automatic scripting.

Let me know

3 Replies

Re: Add Code to Main Header Script

Create the script, save it in a txt file then at the top of your document insert it with an include statement (look in in the help) and finally delete the automatic scripting.

Let me know

Not applicable

Re: Add Code to Main Header Script

Grazie mille Alessandro,

I use:

$(Include=Header.qvs);

And it works!

Thanks!!

Re: Add Code to Main Header Script

Perfect!