topic Modify system variables in QlikView

Modify system variables

Thu, 03 Jun 2010 11:02:31 GMT

Hi!

I want to modify the system variable "MonthNames" without reloading all the tables in my script. In "variables overview" I only have the variables I created.

Thanx.

Modify system variables

Thu, 03 Jun 2010 11:21:14 GMT

I don't think it is possible to change a system variable. What do you want to accomplish with this, their might be an other way.

Thanks,

Modify system variables

Thu, 03 Jun 2010 13:01:46 GMT

In my script I had

SET

MonthNames = 'Jan;Fev;Mar;Avr;Mai;Juin;Juil;Auo;Sep;Oct;Nov;Dec' ;

I am trying to modify the names of months. I had already modify the names when I reloaded the first time. When I use month(date), the system change the month number by one of the names I put ('Jan;Fev;Mar;Avr;Mai;Juin;Juil;Auo;Sep;Oct;Nov;Dec' ). I want to modify these names because of a mistake in the text but I don't want to reload all the script.

I hope I m understandable.

Thanx.

Modify system variables

Thu, 03 Jun 2010 13:07:00 GMT

Do this wth an IF statement in the expression.

Please send me the faulty months.

Ex "Jam" should be "Jan" etc.

I will give you a expression t fix this.

Modify system variables

Thu, 03 Jun 2010 13:23:50 GMT

The mistake is only for the 8th month. I have "Auo" instead of "Aou".

Thanx!

SV:Modify system variables

gandalfgray — Thu, 03 Jun 2010 13:26:58 GMT

I believe a "partial reload" would do what you want.

Ctrl+Shift+R

or you'll find it in the File menu

SV:Modify system variables

Thu, 03 Jun 2010 13:29:12 GMT

If you're still struggling with it, this macro works:

Sub SET_Vars
ActiveDocument.Variables("MonthNames").SetContent "J;F;M;A;M;J;J;A;S;O;N;D", true
END SUB

SV:Modify system variables

Thu, 03 Jun 2010 13:44:02 GMT

I have tried with "replace load... " for all my calendars after I modified the "set MonthFormat=..." and I did a partial reload but nothing changed. I think the partial reload don't consider my modification in the "Set". I will try the macro.

thanx.