Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.