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: 
StacyCui
Creator
Creator

Number format

Hi,  I have three number. When I use PY Potential -(Competitor Volume+PYOR),  it shows 7.11f,   Why it doesn't show 0?  For the script, I convert the number into decimal and then sum, Does it influence the results?

StacyCui_0-1679291567548.png

StacyCui_1-1679291643876.png

 

Labels (2)
1 Solution

Accepted Solutions
StacyCui
Creator
Creator
Author

I have solved this issues, Multiple  100 and then use round() . Thank you so much for your reply.

View solution in original post

3 Replies
BrunPierre
Partner - Master II
Partner - Master II

Hello, if possible, can you share sample data and expected output?

Vegar
MVP
MVP

7.11f is the ISO notation for the small number 0.00000000000000711. 

Try wrap a Round () around your expression or format the output with desired numbers of decimal.

StacyCui
Creator
Creator
Author

I have solved this issues, Multiple  100 and then use round() . Thank you so much for your reply.