
Creator
2023-03-20
02:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
962 Views
1 Solution
Accepted Solutions

Creator
2023-03-20
08:47 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have solved this issues, Multiple 100 and then use round() . Thank you so much for your reply.
3 Replies

Partner - Master II
2023-03-20
05:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello, if possible, can you share sample data and expected output?
932 Views

MVP
2023-03-20
06:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Vegar
Qlik Community MVP
Qlik Community MVP
927 Views

Creator
2023-03-20
08:47 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have solved this issues, Multiple 100 and then use round() . Thank you so much for your reply.
