topic Re: Add comma inside number in QlikView

Add comma inside number

Mon, 22 Jun 2015 13:57:46 GMT

Hi All,

I have a number stored in my database, example :

"935000" mean "9.35$"

"1356000" mean "13.56$"

So I have to delete the three '0' and insert a comma before the two decimal numbers, but I don't know how to do this, num# and num don't seems to allow me do this, anyone have a solution ?

Thank you fro you help,

Loup

Re: Add comma inside number

Anonymous — Mon, 22 Jun 2015 15:43:54 GMT

try to Format like this and put your numberfield instead of values

=num('1356000'/100000,'0,00$')

Re: Add comma inside number

marcus_sommer — Mon, 22 Jun 2015 15:45:16 GMT

I think you could simply divide your number (and used possibly a numeric converting) like:

num#(NUMBER, '##########') / 100000

- Marcus

Re: Add comma inside number

Mon, 22 Jun 2015 15:53:57 GMT

Thank you,

that was easy to do...

Both answers are good but I prefer to use the num#.