Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data precision if lower than 1

Hello everyone,

I am really new to qlik sense and I have a question. Is there a way to show precised value labels in case the value is lower than 1?

I can see in the number formatting section of the data a filed for customized data. I dont know how I can work with it to show upto 2 digits precision after point for percentage.

Any help will be much appreciated

8 Replies
MK_QSL
MVP
MVP

You can use Num and Num# function for this..

Anonymous
Not applicable
Author

Hi Manish, the number formatting field does not allow expression in Qlik sense, If you can be a bit more specific on how I can do this, that would be great. I only one a single data point that is below 1 to show up until 2 decimal point. For the rest the predefined version is working fine.

MK_QSL
MVP
MVP

Sure.. if you provide sample app along with your requirements, will work on this.

Anonymous
Not applicable
Author

I dont find the option to upload the app here.. I am attaching a screen shot for you: I want the category B to be shown up until 2 decimal point. Is it possible to do it via Qlik sense?

Capture 1.JPG

rupamjyotidas
Specialist
Specialist

You can do something like this in Script

Round([YourValue],0.11)

Anonymous
Not applicable
Author

HI Rupam, but that would change the rest of the graphs that I have created from the same value set. Is it possible to do it for this particular graph only?

rupamjyotidas
Specialist
Specialist

make a new field using the same field

Round([YourValue],0.11) as Yourvalue1

and use YourValue1 in your Bar chart. Everything will be connected as both the fields are in the same table.

rupamjyotidas
Specialist
Specialist

Or write an Expression in chart

If( Sum(YourValue)<1, Round([YourValue],0.11), YourValue)