topic Re: Number Format in QlikView

Number Format

Wed, 10 Feb 2016 21:10:46 GMT

I've the following number: 10,01234

And I want to represent them into this format: 10.012,34

I already try all the formats in number tab but nothing returns what I want.

What comes closest to what I want is :##.##,###

Anyone have any idea?

Thanks

Re: Number Format

Peter_Cammaert — Wed, 10 Feb 2016 21:16:07 GMT

Like this?

=num(YourField * 1000.0, '#.##0,00', ',', '.')

Re: Number Format

Wed, 10 Feb 2016 21:21:18 GMT

Thanks Peter, but it doesn't returns the format that I want

Re: Number Format

Peter_Cammaert — Wed, 10 Feb 2016 21:54:18 GMT

Where is your "number" stored? Is it a text string?

It does work for me though. This script

RawData:

LOAD 10.01234 AS Number AUTOGENERATE 1; // Raw Binary number, default format

Data:

NOCONCATENATE

LOAD *, Num(NumberFormat1 * 1000.0, '#.##0,00', ',', '.') AS NumberFormat2;

LOAD *, Num(Number, '#0,00000', ',') AS NumberFormat1

RESIDENT RawData;

DROP Table RawData;

produces this in a table box (no number tweaking)

See attachment.

Best,

Peter

Re: Number Format

Thu, 11 Feb 2016 01:13:06 GMT

If I multiplicate by 1000 I get the number correct in my chart, however the value of my pop up it isn't correct...

Re: Number Format

Thu, 11 Feb 2016 01:17:00 GMT

Is a bar chart, its a result of a calculation

Re: Number Format

Peter_Cammaert — Thu, 11 Feb 2016 07:52:16 GMT

Please post an example document with this phenomenon, or we will have to guess what exactly you are doing and that may take a while. Thanks

Peter

Re: Number Format

jagan — Thu, 11 Feb 2016 08:15:18 GMT

Hi,

Try like this

=Num(Replace(FieldName, ',', '')/100, '#.##0,00', ',', '.')

Regards,

jagan.

Re: Number Format

t_chetirbok — Thu, 11 Feb 2016 08:21:22 GMT

Hi, cause chart display sum, you should use:

so your result will be like this: