Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

how to display two decimal points in text object

Hi all

Example:

Count(sales) = 100.345625678  (in Text object)

How can i show two decimal points in text object

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
manojkulkarni
Partner - Specialist II
Partner - Specialist II

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

arulsettu
Master III
Master III

try this

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

madhubabum
Creator
Creator
Author

Hi

Thanks ....

It's working fine

Thanks

Madhu

jsingh71
Partner - Specialist
Partner - Specialist

 

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
Master III
Master III

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