topic Separate numbers with quotes (number formatting) in QlikView

Separate numbers with quotes (number formatting)

Mon, 04 Jun 2012 21:27:44 GMT

Hello,

I would like to display the numbers like this:

1000 ==> 1'000

11'000 ==> 11'000

1000000 ==> 1'000'000

I've tried with the num function but without success. Can anyone help me ? Thanks!

Separate numbers with quotes (number formatting)

Sokkorn — Tue, 05 Jun 2012 03:30:40 GMT

Hi,

For me, first we need to formate number into 1,000,000.00 then replace <,> to <'>. Somthing like this =REPLACE(NUM('1000000','###,###.#0'),',',CHR(39))

Regards,

Sokkorn

Separate numbers with quotes (number formatting)

Tue, 05 Jun 2012 22:57:51 GMT

=num(1000000000, '#'&chr(39)&'###.00','.' , chr(39))

Result: 100'00'00'000.00