Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ]
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))
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...
Any ideas anymore?
Update:
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 😞