Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify system variables

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.

7 Replies
Not applicable
Author

Hi

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,

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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

Thanx!

gandalfgray
Specialist II
Specialist II

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

Ctrl+Shift+R

or you'll find it in the File menu

Not applicable
Author

Hi

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


Not applicable
Author

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.