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: 
sweety0912
Contributor II
Contributor II

Need Help on Format

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.

5 Replies
Chanty4u
MVP
MVP

Not tested may be try

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

eduardo_dimperio
Specialist II
Specialist II

Floor(FIELD*10)

shiveshsingh
Master
Master

may be thi

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

Anonymous
Not applicable

Hi,

Try this:

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

mhappiee
Partner - Contributor III
Partner - Contributor III

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