Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nigel987
Contributor II

Num Format with Hashes

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')
16.##0,00
21001.##0,00
315465487.##0,00

KR Nigel


5 Replies
qlikmeplease
Contributor III

Re: Num Format with Hashes

Good Day,

The the below:

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

Regards,

Highlighted
nigel987
Contributor II

Re: Num Format with Hashes

Hi,

it still doesn't show the thousand separators

Test Num#(Zahl,'#.##0,00')
15,89
21000,5
315465486,53

But this is better than before! Thanks

qlikmeplease
Contributor III

Re: Num Format with Hashes

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,

nigel987
Contributor II

Re: Num Format with Hashes

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;

chinnuchinni
Contributor III

Re: Num Format with Hashes

Hi ,

you can use bellow;

LOAD Test,

     Zahl,

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

FROM

XXXXX ;