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: 
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.