Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

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

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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
Author

Grazie mille Alessandro,

I use:

$(Include=Header.qvs);

And it works!

Thanks!!

alexandros17
Partner - Champion III
Partner - Champion III

Perfect!