Data precision if lower than 1

[Anonymous]

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

[MK_QSL]

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

[Anonymous]

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]

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

[Anonymous]

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?

[rupamjyotidas]

You can do something like this in Script

Round([YourValue],0.11)

[Anonymous]

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]

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]

Or write an Expression in chart

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