topic Re: Need Help on Format in QlikView

Need Help on Format

sweety0912 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 18 May 2018 16:52:37 GMT

Not tested may be try

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

eduardo_dimperio — Fri, 18 May 2018 19:03:17 GMT

Floor(FIELD*10)

shiveshsingh — Sat, 19 May 2018 04:21:30 GMT

may be thi

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

Anonymous — Sat, 19 May 2018 04:33:29 GMT

Hi,

Try this:

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

mhappiee — Sat, 19 May 2018 05:14:02 GMT

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

Hope this helps

Anand