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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
fabdulazeez
Partner - Creator III
Partner - Creator III

Only Number 5 displayed as 5.0

We are computing a measure value and using floor to remove decimal places. Only when the value is 5 it is displayed as 5.0. We are building a generic table and hence measure value can have different data type. But the computation logic for 1 type is  same and we are expecting the same format. 

 

fabdulazeez_0-1689829575332.png

 

It behaves normal When  I add zero to it 

Measure_Value+0 as Measure_Value

 

 

fabdulazeez_1-1689829873919.png

 

 

 

Can Anyone show how I need to debug this issue or should I raise a support ticket for same. We  are using Sense November 2022 Client Managed,

Labels (2)
1 Reply
Or
MVP
MVP

Floor(5) and Floor(5.1) both return 5 on my end, formatted without a decimal point.

As this seems to be a formatting issue, you could just use num() to format the result explicitly.