topic Re: How to format comma separate in text object in QlikView

How to format comma separate in text object

Thu, 21 Nov 2013 12:16:50 GMT

I tried to have comma separate between the value in the text object, any idea this can be achieved?

Anonymous — Thu, 21 Nov 2013 12:20:29 GMT

Heok

Try using this as you text box expression:

='$ ' & num(round(sum({1<keyExpType={'Tier1Capital'}>}exposure),1),'#,##0')

Best Regards, Bill

Thu, 21 Nov 2013 12:22:27 GMT

try to use num() format

Thu, 21 Nov 2013 12:25:53 GMT

try according to this example

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

CELAMBARASAN — Thu, 21 Nov 2013 12:29:53 GMT

Change all you expression like this

=Num(Round(Sum({1<keyExpType={'Tier1Capital'}>}exposure), 1), '$ #,##0')

saumyashah90 — Thu, 21 Nov 2013 12:31:29 GMT

Do this,

If you need a integer

Num(FieldName,'#,##0')

If you want two decimal

Num(FieldName,'#,##0.00')

If you want any number

Num(FieldName,'#######,###')

For % in any

just add % at the end

for example

In decimal

Num(FieldName,'#,##0.00%')

Thu, 21 Nov 2013 13:10:12 GMT

varaprasad0816 — Fri, 05 Jun 2020 07:23:31 GMT

Yes,It is working fine.

thank you

Regards,

Vara