Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

change settings of multiple objects at once

Hallo everyone, 

i'm currently constructing multiple QlikSense Apps for auto-generating reports via NPrinting. 
Therefor i have to change quite often attributes like "sort order", "number format" and "totals function" (because 'auto' doesn't fit). 

For example right now i have a workingsheet with 8 tables on it, each having about different 10 measures that doesn't display properly in sight of the 3 above mentioned attributes.

Is there a way to save some time doing changes like these for multiple objects or multiple measures/dimensions ? It's a real pain to click through 80 objects to change their number-format, totals function and sort-order - especially when in 90% of all occurances ALL ARE THE SAME 😞


[ To exclude the option of "alternate states" right away: These don't work with NPrinting, so this isn't an option for me ]

4 Replies

Re: change settings of multiple objects at once

I suggest you to make different variable and call then in format area like

SET Format = '#,#0.00';

In the expression in all 80 objects call it out, And change in the variable as per need and It will reflect in all area.

Num(sum(Sales), $(Format))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor III

Re: change settings of multiple objects at once

Does someone have another idea, that avoids changing the definition of 80 measures per worksheet? Changing definitions isn't that much of a time-saver, compared to change em 1 by 1 manually by clicking... (although good hint for the future - Thanks @Anil_Babu_Samineni )

In the Script, i have a section saying:
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

I don't quite understand, why it isn't auto-formatted properly right away, when i sum order-amount-values later in measures and add them to tables... 

New Contributor III

Re: change settings of multiple objects at once

Any ideas anymore?

New Contributor III

Re: change settings of multiple objects at once


After some adjustments to the Syntax of Anil_Babu_Samineni's suggestion, it saved me at least some time - so maybe it helps someone:

with setting

SET Format = '''#.##0'' , '','' , ''.'''

and applying

Num(<fieldname>, $(Format))

to all integer-valued fields in the Load-part of the script, changes the definition of all measures using these fields, too. Therefor, the values are showing up properly right away by the auto format. 

pretty nice trick, although not solving the sort- and total function problem, that really seems to be changed 1 by 1 😞