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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
retko1985
Creator II
Creator II
‎2017-10-16 06:47 AM

Format number without decimal separator ending with zeros

Hello,

I want to format number with 2 digits after decimal, but is those digits are ,00 then they will not appear.

Like if it is 50,40 it will be like this, if it is 50,00 it will make 50. If I choose fixed, it gives me 50,00

Thank you.

1,599 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-10-16 06:50 AM

50,00 is not the 50. If it is decimal then it is 50.. Are you sure about expectation?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
1,480 Views
0 Likes
swuehl
MVP
MVP
‎2017-10-16 07:00 AM

Maybe use a conditional with different number formatting, like shown in

Round number when two digits after decimal is zero

1,480 Views
0 Likes