topic Re: Number formatting in QlikView

Number formatting

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

This is just too ridiculous to ask but ...

I have a formula

=num(AGGR(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '##%')

As you can see at the end of the formula, I have formatted it to 2 figures. However, I may come across 100% which will give me the result of 1.e05 yada %

So I then change my formula to

=num(AGGR(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '###%')

which means I will then get 100% as required but I will also get 25.9 or 59.5 but I don't want that decimal place.

I want whole numbers.

Any ideas?

Re: Number formatting

sunny_talwar — Tue, 21 Jul 2015 14:32:59 GMT

I don't think you will get decimals with this '###%'. For decimals you would need this: '###.#%'

Re: Number formatting

antoniotiman — Tue, 21 Jul 2015 14:34:00 GMT

......,'#0%')

Re: Number formatting

ramoncova06 — Tue, 21 Jul 2015 14:38:53 GMT

this should work #,##0%

Re: Number formatting

bobbydave — Tue, 21 Jul 2015 14:39:46 GMT

Hero!