topic Re: Thousands Format in Text Label in QlikView

Thousands Format in Text Label

microwin88x — Thu, 13 Mar 2014 17:40:09 GMT

Hello!

Is there any way to show in a Text Label Object, for example the number 35275 as 35.275? (In Thousands)

What function could I use?

Thank you!!!

Re: Thousands Format in Text Label

giakoum — Thu, 13 Mar 2014 17:43:27 GMT

num(fieldname, '#,##0')

Re: Thousands Format in Text Label

Gysbert_Wassenaar — Thu, 13 Mar 2014 17:43:38 GMT

Use the num function: =num(35275,'#.##0' , ',' , '.')

Re: Thousands Format in Text Label

Anonymous — Thu, 13 Mar 2014 17:44:16 GMT

why not simply divide the number by 1000...something like this

='Number in 1000s is '&35275/1000

replace 35275 with your field name.

also, you could use num function and keep an eye on what your thousand separator is. if you need a decimal for 1000 separator, you will have to SET it in the script in your main tab (ThousandSep)

Re: Thousands Format in Text Label

its_anandrjs — Thu, 13 Mar 2014 17:44:17 GMT

Hi,

Use Num function.

Thanks & Regards

Re: Thousands Format in Text Label

Thu, 13 Mar 2014 17:46:35 GMT

When new QVW's are started there is a section of settings that are created for you including the thousands separator. If you change them and then apply formatting you'll get your result

SET MoneyThousandSep =',';
SET MoneyDecimalSep ='.';
SET MoneyFormat ='$#,##0.00;($#,##0.00)';

Re: Thousands Format in Text Label

maxgro — Thu, 13 Mar 2014 17:49:32 GMT

you can try and copy format-code parameter of num function from here

Re: Thousands Format in Text Label

its_anandrjs — Thu, 13 Mar 2014 17:50:40 GMT

Hi,

Use some thing like this

num(35275, '#.##0')

and set thousand separator like

SET ThousandSep='.';

in script editor

Thanks & Regards