Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

martinqlik
New Contributor III

help formatting numbers

Hello, Qlikers!

I have values in my project that eventually comes into different format from database. I can't use same format pattern for all of them because that problem. I have an example below:

DB               How I need to format

35545875  =         35.545

31294345  =         31.294

44100.7     =         44.100

43250.7     =         43.250

1328         =          1.328

12.9          =           12.9

Does anyone have faced something like that?

Tks,

2 Replies
YoussefBelloum
Esteemed Contributor

Re: help formatting numbers

Hi,

maybe try this on the script:

Num(FIELD, '#,##0', '.' , ',' ) as FIELD

YoussefBelloum
Esteemed Contributor

Re: help formatting numbers

Or this:

Num(FIELD, '#.##0', ',' , '.' ) as FIELD