topic Formatting Numbers in QlikView

Formatting Numbers

Mon, 20 Feb 2012 15:27:51 GMT

Dear community,

i'm very embarassed to ask, but is it somehow possible to format numbers in this way:

Step1: 14960

Step2: 14.960

Step3: 14 TEUR

Step1 to Step2 is easy. But i totally fail at Step3. 😞

How can i do that?

Regards,

donuteater

Mon, 20 Feb 2012 15:39:22 GMT

Obviously, i'd format it in Excel like this

"#.##0."

But this doesn't work, since it does seriously destroy the whole format of the number.

🙂

swuehl — Mon, 20 Feb 2012 18:48:37 GMT

In your format, you are using two times the 'dot' I suppose you want to use one time dot and one time the comma as thousand resp. decimal separator?

So, a full format might look like:

=num(14960,'#.##0,0',',','.')

or without the decimal separator:

=num(14960,'#.##0',',','.')

and if you want to get to step 3:

=num(14960/1000,'#.##0',',','.')&' TEUR'

or without rounding:

=num(floor(14960/1000),'#.##0',',','.')&' TEUR'

Use all these expression e.g. in a text box, and you could also replace the 14960 constant with a field name.

=num(floor(FACTFIELD/1000),'#.##0',',','.')&' TEUR'