I am, as I type, attending the 3-day Qliktech developer course and a question has arisen that no-one here knows the answer to. When one starts a new Qlikview document a number of elements are set automatically including the Money Format:-
MoneyFormat='£#,##0.00;-£#,##0.00'; Adjusting this on the Main tab sets the default for the entire document and prevents a user needing to adjust this on every chart developed.
It would be great to set the Integer format for the entire document here too, specifically so that negative numbers default to appearing with brackets rather than a minus sign.
Does anyone know if this is possible and, if so what should be included at the start of the script?
as you said, MoneyFormat, DayName and so, in the script editor they all are Document Default variable,
if you go to Settings>> Variable Overview>> here you will see all document variables,
but there is no variable like number setting or so in the default document variable.
But you can create one for your document, and you can use where ever you want, but qlikview will not take it automatically like moneyformat. you have to pass this one in expression, where ever you want to use...
you can use num function to format any numeric field, so it would have this default format. Also, you can override this format in specific charts in properties > number tab, assigning a different format if you need so.