topic Re: Num Format with Hashes in QlikView

Num Format with Hashes

nigel987 — Wed, 10 Oct 2018 06:33:00 GMT

Hi, I want to display numbers with thousand separator '.' and two decimals.

Data:

LOAD * INLINE [

Test, Zahl

1, "5,89"

2, "1000,5"

3, "15465486,53"

];

NoConcatenate

Temp:

Load

Test,

Num(Zahl,'#.##0,00')

Resident Data;

Drop Table Data;

But my numbers get displayed with hashes. How can I change that?

Test	Num(Zahl,'#.##0,00')
1	6.##0,00
2	1001.##0,00
3	15465487.##0,00

KR Nigel

Re: Num Format with Hashes

Anonymous — Wed, 10 Oct 2018 07:15:01 GMT

Good Day,

The the below:

Num#(Zahl,'#.##0,00')

Regards,

Re: Num Format with Hashes

nigel987 — Wed, 10 Oct 2018 07:30:01 GMT

Hi,

it still doesn't show the thousand separators

Test	Num#(Zahl,'#.##0,00')
1	5,89
2	1000,5
3	15465486,53

But this is better than before! Thanks

Re: Num Format with Hashes

Anonymous — Wed, 10 Oct 2018 07:52:20 GMT

It is just because the table has been INLINE loaded, so it pulls through with the Comma in it, if you are pulling from a numerical format it should be correct.

Regards,

Re: Num Format with Hashes

nigel987 — Wed, 10 Oct 2018 08:53:56 GMT

When I use this file as a basis, it still doesn't show the thousand separators

Data:

LOAD Test,

Zahl

FROM

yourPath\TestFile NumFormat.xlsx

(ooxml, embedded labels, table is Tabelle1);

NoConcatenate

Temp:

Load

Test,

Num#(Zahl,'#.##0,00') AS Zahl

Resident Data;

Drop Table Data;

Re: Num Format with Hashes

chinnuchinni — Wed, 10 Oct 2018 10:03:50 GMT

Hi ,

you can use bellow;

LOAD Test,

Zahl,

Num(Zahl,'#,##0.00') as Zahl2

FROM

XXXXX ;