topic Re: Remove Decimal in QlikView

Remove Decimal

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

I have a column where values get changed depending on the decimal values like if it is 20.5 then it converted to 20 and if it is 20.75 then it is converted to 21. Can anyone help me? How can I do these in qlik sense .

Re: Remove Decimal

sunny_talwar — Tue, 19 Jun 2018 16:39:39 GMT

Have you tried Round() function

Re: Remove Decimal

Chanty4u — Tue, 19 Jun 2018 16:40:18 GMT

have a look

Rounding Errors

Re: Remove Decimal

Anonymous — Tue, 19 Jun 2018 19:25:12 GMT

Yes ,I tried but it is not working.Both is converted to 21.Even I used floor and ceil function but still I am not able to implement both in a single column.

Re: Remove Decimal

Chanty4u — Wed, 20 Jun 2018 05:44:51 GMT

have a look

where we use floor() and ceil() in qlikview?

Re: Remove Decimal

jyothish8807 — Wed, 20 Jun 2018 06:18:58 GMT

May be try this:

if(subfield(sum(F1),'.',2)<=5,floor(sum(F1)),ceil(sum(F1)))

Where F1 is your field.

Re: Remove Decimal

Anonymous — Wed, 20 Jun 2018 10:15:38 GMT

it contains 60.75 ,134.5 and 26.5 and i want 61,134 and 26.

Re: Remove Decimal

jyothish8807 — Wed, 20 Jun 2018 15:53:19 GMT

Hi bhanu,

Have you tried the above solution?

It should give you expected output.

Br,

Re: Remove Decimal

jyothish8807 — Wed, 20 Jun 2018 15:55:14 GMT

May be this:

if(left(subfield(sum(F1),'.',2),1)<=5,floor(sum(F1)),ceil(sum(F1)))

Re: Remove Decimal

atoz1158 — Wed, 20 Jun 2018 16:33:00 GMT

I have used this in past and it works well

=Floor(F1 + 0.48)

Where F1 is the field you wish to adjust.

You can change the addition of 0.48 to suit where you need to round up or down at

for example adding 0.2 will round up .8 but will round down .75

HTH

Adrian