Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
bobbydave
Contributor III

Number formatting

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?

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Number formatting

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

4 Replies

Re: Number formatting

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

antoniotiman
Honored Contributor III

Re: Number formatting

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

ramoncova06
Valued Contributor III

Re: Number formatting

this should work  #,##0%

bobbydave
Contributor III

Re: Number formatting

Hero!