topic Re: Can we show somehow these very high numbers in standard format in App Development

Can we show somehow these very high numbers in standard format

Digvijay_Singh — Fri, 16 Mar 2018 02:45:47 GMT

Hello,

Let me know if there is any way to change these very high/low numbers in normal format like '#,##0.00' format. I have used Money(Value,'#,##0.00') in the expressions. Thanks in advance for the help!

Re: Can we show somehow these very high numbers in standard format

Chanty4u — Fri, 16 Mar 2018 06:29:45 GMT

just an idea .

can you create a inline table in script like current format and map that and use as a format ?

and here what you want to see instead of big number ?

Re: Can we show somehow these very high numbers in standard format

Digvijay_Singh — Fri, 16 Mar 2018 06:35:53 GMT

I think its because Qlik has limitation of showing max 14 diigits, if you see numbers in the chart, they are converted into scientific notation(e+20 at the end). I need to avoid that and show the standard format.

Re: Can we show somehow these very high numbers in standard format

Chanty4u — Fri, 16 Mar 2018 06:36:47 GMT

Ohh is it?

what is your measure and their input values?

Re: Can we show somehow these very high numbers in standard format

Chanty4u — Fri, 16 Mar 2018 06:37:57 GMT

did you tried to change set money format and see?

SET MoneyFormat='₹ #,##0.00;₹ -#,##0.00'; [this is by default - you can change here and try]

Re: Can we show somehow these very high numbers in standard format

Digvijay_Singh — Fri, 16 Mar 2018 06:45:35 GMT

Format is fine for 99% cases. Its showing scientific notation only for very large number. If you see the image, you can see few numbers in proper format with 2 decimal points.

Re: Can we show somehow these very high numbers in standard format

Chanty4u — Fri, 16 Mar 2018 06:48:48 GMT

yes I'm able to see youssefbelloum‌ or omar bensalem can have some idea on this

Re: Can we show somehow these very high numbers in standard format

Chanty4u — Fri, 16 Mar 2018 06:54:15 GMT

can you share sample qvf ?

Re: Can we show somehow these very high numbers in standard format

jonathandienst — Fri, 16 Mar 2018 07:25:21 GMT

There's no easy way to display 20 digit numbers in that format. Why would you want to do that anyway? Would it not be better to convert the entire chart into larger units?

You could try a Dual() value like this (partially tested):

=Dual(If(N >= 1E13, Num(Floor(N / 1E12), '# ##0', '.', ' ')) & ' ' & Num(N - Floor(N / 1E12) * 1E12, '# ##0', '.', ' '), N)

Where N is the expression or value to be formatted.

Re: Can we show somehow these very high numbers in standard format

Chanty4u — Fri, 16 Mar 2018 07:26:45 GMT

Did you check this?

Re: Number formatting - millions to billions

Re: Can we show somehow these very high numbers in standard format

YoussefBelloum — Fri, 16 Mar 2018 08:46:25 GMT

or maybe divide this measure by 1 billion.. and put a symbol of billion (B) on the number section ?

Re: Can we show somehow these very high numbers in standard format

Digvijay_Singh — Fri, 16 Mar 2018 16:20:49 GMT

I think you are right, Needs to build the larger units dynamically in the expressions.

Re: Can we show somehow these very high numbers in standard format

oliveira1903 — Tue, 19 Oct 2021 22:34:47 GMT

Hello, there. =]

I have a simmilar problem. Is there a way to convert into a numeric field like that '$#.##0,00' (money)?

My field is showing this 1,334244462e+15 insted of $1.334.244.462.000.000. Is it possible?

Thanks a lot.

Re: Can we show somehow these very high numbers in standard format

oliveira1903 — Tue, 19 Oct 2021 22:48:10 GMT

Hello, there. =] @jonathandienst

I have a simmilar problem. Is there a way to convert into a numeric field like that '$#.##0,00' (money)?

My field is showing this 1,334244462e+15 insted of $1.334.244.462.000.000. Is it possible?