Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerhardl
Creator II
Creator II

Format number within expression

Hi,

How can I limit the number of decimals within my expression?

I have an expression in my chart title, which is supposed to show me 22% but I don't know how to format it, so it shows 0.2212341241 or something. I can of course multiply with 100, but I want it to round off (have no decimals, or just one is also okay).

Here is the title of my gauge chart:

='Credit Utilisation (Limit Spent) - '& Sum (Limit-[OTB (excl. oversell)])/Sum (Limit)*100

13 Replies
Anonymous
Not applicable

try

=num('Credit Utilisation (Limit Spent) - '& Sum (Limit-[OTB (excl. oversell)])/Sum (Limit)*100),'#,##0.00%') or Properties

1.PNG

sunny_talwar

Guys do you realize that this post is from 2011? They might have already solved the issue.

Just wanted to let you know if you did not already know.

Best,

Sunny

md_anasabbasi
Contributor III
Contributor III

Hi Sunny,

     Is there a way to round your number up to the nearest million, e.g. 2,893,754,164 so if I write it in million it should be 2,894M not 2,893M because I want to round up. But everywhere I see they suggest to divide the number by 1 million and add M at the last.

Thanks,

Anas

tresesco
MVP
MVP

Ideally, you should have created a new thread for not so-much related topic help.

You can use Ceil() like:   Ceil( <number> , 1000000 ) &'M'