Solved: Cut a Decimal off at a Certain spot without Roundi... - Qlik Community

Anonymous · ‎2014-03-21

I have decimals that are computed in our system and come out to something like this 0.197378 that it cuts down to 0.1973 on reports. When I limit the decimal places in QlikView it becomes 0.1974. I have tried using the num function and cannot seem to get the floor function to work, so I wanted to see if there was another way to cut numbers off at a certain decimal and not round them.

SunilChauhan · ‎2014-03-21

in GPD use below expression

floor(num(Sum(Gain_lbs_b) / SUM(Processed_head) / Round((sum(AgeInDays * Processed_head) / SUM(Processed_head)), 1.0),'#.####'),.0001)

hope this helps

Sunil Chauhan

View solution in original post

jerem1234 · ‎2014-03-21

I would think something like:

floor(Field, .0001)

would work.

Anonymous · ‎2014-03-21

When I put my expression in the floor function it does not compute, but the num function does. Any idea why?

jerem1234 · ‎2014-03-21

Hmm could you post a small sample qvw that demonstrates this?

Report Inappropriate Content · ‎2014-03-21

Maybe Floor(num(Field),.0001)

Anonymous · ‎2014-03-21

This runs with no errors, but doesn't return a result.

Report Inappropriate Content · ‎2014-03-21

Not sure why its not working for you. Attached is a sample. Is the number in number format?

SunilChauhan · ‎2014-03-21

=floor(num(0.197378,'#.####'),.0001)

or

floor(num(fieldname,'#.####'),.0001)

Sunil Chauhan

Anonymous · ‎2014-03-21

Does it matter that I am trying to do this in a calculated expression in a chart?

SunilChauhan · ‎2014-03-21

you can attached sample

we will have a look

Sunil Chauhan

Cut a Decimal off at a Certain spot without Rounding