topic Cut a Decimal off at a Certain spot without Rounding in QlikView

Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 18:16:17 GMT

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.

Re: Cut a Decimal off at a Certain spot without Rounding

jerem1234 — Fri, 21 Mar 2014 18:22:46 GMT

I would think something like:

floor(Field, .0001)

would work.

Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 18:35:03 GMT

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

Re: Cut a Decimal off at a Certain spot without Rounding

jerem1234 — Fri, 21 Mar 2014 18:43:23 GMT

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

Re: Cut a Decimal off at a Certain spot without Rounding

Fri, 21 Mar 2014 19:00:51 GMT

Maybe Floor(num(Field),.0001)

Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 19:13:03 GMT

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

Re: Re: Cut a Decimal off at a Certain spot without Rounding

Fri, 21 Mar 2014 19:17:19 GMT

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

Re: Cut a Decimal off at a Certain spot without Rounding

SunilChauhan — Fri, 21 Mar 2014 19:18:18 GMT

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

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

Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 19:22:19 GMT

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

Re: Cut a Decimal off at a Certain spot without Rounding

SunilChauhan — Fri, 21 Mar 2014 19:23:14 GMT

you can attached sample

we will have a look

Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 19:24:26 GMT

Sorry, but how do I attached qvw file?

Re: Cut a Decimal off at a Certain spot without Rounding

SunilChauhan — Fri, 21 Mar 2014 19:25:39 GMT

go to reply-> use advance editor -> attached file

Re: Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 19:38:59 GMT

I'm working with GPD expression in chart.

Re: Cut a Decimal off at a Certain spot without Rounding

jerem1234 — Fri, 21 Mar 2014 19:45:53 GMT

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

seems to be working for me. Using version 11 SR2. Might be a bug with your version of Qlikview.

Re: Cut a Decimal off at a Certain spot without Rounding

SunilChauhan — Fri, 21 Mar 2014 19:50:46 GMT

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

Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 20:06:21 GMT

That worked, I was leaving out the 1 at the end.

Re: Cut a Decimal off at a Certain spot without Rounding

Anonymous — Fri, 21 Mar 2014 20:07:11 GMT

That worked, I left out 1 at the end.

Thanks to everyone for your help. You made my weekend.