Add Code to Main Header Script

Fri, 11 Jul 2014 09:31:23 GMT

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

Re: Add Code to Main Header Script

alexandros17 — Fri, 11 Jul 2014 09:35:52 GMT

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

Re: Add Code to Main Header Script

Fri, 11 Jul 2014 10:07:12 GMT

Grazie mille Alessandro,

I use:

$(Include=Header.qvs);

And it works!

Thanks!!

Re: Add Code to Main Header Script

alexandros17 — Fri, 11 Jul 2014 10:09:39 GMT

Perfect!

topic Add Code to Main Header Script in QlikView

Add Code to Main Header Script

Re: Add Code to Main Header Script

Re: Add Code to Main Header Script

Re: Add Code to Main Header Script