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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.