Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
Partner

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

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

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
Partner

 

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.