topic Re: Format numbers in textfield in QlikView

Format numbers in textfield

Wed, 25 Nov 2020 16:16:04 GMT

Hey community I'm trying to format a number that I calculate in a textfield. It's part of a dashboard but the huge amounts just makes everything very hard to interpret. This is now divided by 1000 jsut to make it readable. But I would like to have int format on these figures, or maybe 1,2 decimals. Not needing to divide it by 1000 and using Round function.

Re: Format numbers in textfield

avinashelite — Tue, 23 Aug 2016 08:11:33 GMT

Did you tried using the num() function

Num( field/Expression ,'#,##0 ')

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm

Re: Format numbers in textfield

Anonymous — Tue, 23 Aug 2016 08:12:19 GMT

use the num function around each of your fieldnames

num(yourvalue,'#.##0,0 ') -> shows 1 decimal

Re: Format numbers in textfield

Tue, 23 Aug 2016 10:57:25 GMT

=Sum({<ValueName={'Commission|Total'}>}ValueSEK)

How would you make the syntax?

Re: Format numbers in textfield

mdmukramali — Tue, 23 Aug 2016 11:01:52 GMT

Dear ,

for 2 decimal

=Num(Sum({<ValueName={'Commission|Total'}>}ValueSEK),'#,##0.00')

with out decimal.

=Num(Sum({<ValueName={'Commission|Total'}>}ValueSEK),'#,##0')

Thanks,

Mukram

Re: Format numbers in textfield

Tue, 23 Aug 2016 11:21:25 GMT

Sorry i maybe explained badly but I what i want to acheive is like an int formatted. like this 1 234 567 89 not like 123456789. Does that make it clearer?

Re: Format numbers in textfield

adamdavi3s — Tue, 23 Aug 2016 11:24:14 GMT

Rob has a very neat way of doing this for this sort of situation.

I recently used this in the production of my KPI figures:

http://qlikviewcookbook.com/2016/05/scaling-numbers-and-dse-tips/