topic Re: Large number formatting issue in QlikView

Large number formatting issue

Wed, 24 Oct 2012 14:12:50 GMT

I have an interesting problem when I'm trying to format large numbers in any type of object (pivot table, text object, etc). I am using QlikView 10 SR4. Is there any workaround for this, other than dividing the number to get a value that QlikView can display (which I need to avoid at any cost)?

I am also attaching an example.

Re: Large number formatting issue

CELAMBARASAN — Wed, 24 Oct 2012 14:25:21 GMT

Go to Properties-->Number tab-->Select your expression-->Click the number format as number then provide format pattern as expected number of digits as #'s. Then you will get it.

Re: Large number formatting issue

lironbaram — Wed, 24 Oct 2012 14:29:35 GMT

see attach file

in the number tab look at the format i gave the first two expressions

Re: Large number formatting issue

Wed, 24 Oct 2012 14:49:55 GMT

Thanks to both of you, that seems to be displaying the number. However, what's the solution for not displaying the decimals (as I am not interested to see them)? I can round the number in the expression using Round() or is there a way to achieve the same thing using number formatting in the properties of the object? I know the normal way of formatting the number without decimals, but it doesn't seem to be working in this particular case.

Re: Large number formatting issue

CELAMBARASAN — Wed, 24 Oct 2012 14:54:46 GMT

Don't specify the #'s for the decimal values

Example:

with decimal: ####.##

w/o decimal values will be ####

Re: Large number formatting issue

Wed, 24 Oct 2012 14:55:33 GMT

delete the .00 from the formating.

Re: Large number formatting issue

Wed, 24 Oct 2012 16:08:33 GMT

The solution that liron baram attached above works fine, but only with a certain formatting (which allows decimals). If I try to format it to get the number to have another format (comma separator for thousands, no decimals) it doen't seem to be working. Can you please have a look at the file attached by liron baram and format the second expression in the table?

Re: Large number formatting issue

Gysbert_Wassenaar — Wed, 24 Oct 2012 16:20:30 GMT

Works for me. If you change the thousands separator in the Format Pattern, don't forget to change it below under Separators too. Actually change the separators first, since that immediatly updates the Format Pattern so that it looses the extra #'s you need.

Re: Large number formatting issue

Wed, 24 Oct 2012 16:34:23 GMT

Can you attach your QVW with the correct formatting of the second expression? I'm missing something here.

Re: Large number formatting issue

Gysbert_Wassenaar — Wed, 24 Oct 2012 16:52:46 GMT

Ah, I see that you mean. This one can't be formatted correctly directly: 1,627,627,432.507066. But with a little change to the expression to get rid of the decimals it can be formatted as you wish: round(Sum(Amount)/0.000123124).