Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Limit number of decimal on load

How would I limit number of decimal to only 2 in the load statement?

My numbers come with different number of decimals.

E.g.

if it's a whole number -  259.00000 (number of zeros vary) - I want this to be 259

if it's not  - 485.9994 , 323.25, 101.444 - I want this to be 485.99, 323.25, 101.44

1 Solution

Accepted Solutions
Highlighted

Re: Limit number of decimal on load

May be using Num() function

Num(NumberField, '#,##0.00') as NumberField

View solution in original post

5 Replies
Highlighted

Re: Limit number of decimal on load

May be using Num() function

Num(NumberField, '#,##0.00') as NumberField

View solution in original post

Highlighted
Not applicable

Re: Limit number of decimal on load

Will this make 259.00 or 259? I would need the latter.

Highlighted
Specialist
Specialist

Re: Limit number of decimal on load

Hi,

you can also try it in front end.

properties-->number tab-->Capture.PNG

you can override as you can...

--surendra

Highlighted
Not applicable

Re: Limit number of decimal on load

Thanks Surendra. I am aware of this option. However, I need it to be on LOAD

Highlighted

Re: Limit number of decimal on load

259.00