topic Re: how to display two decimal points in text object in QlikView

how to display two decimal points in text object

madhubabum — Thu, 25 Jun 2015 06:53:22 GMT

Hi all

Example:

Count(sales) = 100.345625678 (in Text object)

How can i show two decimal points in text object

jonathandienst — Thu, 25 Jun 2015 06:54:17 GMT

=Num(Count(sales), '0.00', '.', ' ')

manojkulkarni — Thu, 25 Jun 2015 06:54:40 GMT

num(count(sales)),'#,##0.00')

arulsettu — Thu, 25 Jun 2015 06:55:20 GMT

try this

=num(Count(sales),'#,##0.00')

madhubabum — Thu, 25 Jun 2015 07:04:49 GMT

Thanks ....

It's working fine

Thanks

Madhu

jsingh71 — Thu, 25 Jun 2015 07:05:03 GMT

Under Textbox text write:

=Num(100.345625678,'#.## ')

or if you want to use any field then mention your field name like

=Num(Field_name,'#.## ')

arulsettu — Thu, 25 Jun 2015 07:24:08 GMT

you are welcome. please mark it as answer if it works.