Need Help on Format

[sweety0912]

Hello,

My Y - axis values are like shown below.

3.106, 3.282, 3.370, 3.903 ...etc i want to convert this values to 31, 32, 33,39...etc

Please let me know how can i achieve this.

[Chanty4u]

Not tested may be try

please try as Dim from your chart  num(Dim, '00')

[eduardo_dimperio]

Floor(FIELD*10)

[shiveshsingh]

may be thi

=num(Field*10,'##')

[Anonymous]

Hi,

Try this:

=num(sum(FiledName),'#,##0')

[mhappiee]

Hi

May be u can use a simple round function like below

Round( 3.88 , 0.1 )

Returns 3.9

For more about round please find the link below

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/GeneralNu...

Hope this helps

Anand