topic Re: Round() function in QlikView

Round() function

Emmanuelle__Bustos — Fri, 22 Sep 2017 17:47:47 GMT

Hi I need to use the Round() function in order to round the data whit this logic:

If the data has any decimal values it is rounded to .5 or next integer, if the data has no decimal values it remains as it is (integer).

is this possible: ie.

1.2 --> 1.5

1.6 --> 2

4 --> 4

hope you can help me.

Re: Round() function

vvira1316 — Fri, 22 Sep 2017 18:24:35 GMT

Hi,

Decimal part

=If(IsNull(SubField(RoundingNumbers, '.', 2)), 0, SubField(RoundingNumbers, '.', 2))

Rounded Number

=If(IsNull(SubField(RoundingNumbers, '.', 2)), RoundingNumbers,
If(SubField(RoundingNumbers, '.', 2) <=5, Num#(SubField(RoundingNumbers, '.', 1) & '.' & '5'), Num#(SubField(RoundingNumbers, '.', 1) +1)))

BR,

Vijay

Re: Round() function

sunny_talwar — Fri, 22 Sep 2017 18:48:11 GMT

Might be easier to use Frac function here

If(Frac(Number) > 0, Ceil(Number, 0.5), Number)

or just this

Ceil(Number, 0.5) as Number

Re: Round() function

sunny_talwar — Fri, 22 Sep 2017 18:50:39 GMT

Check this out

Table:

LOAD Number,

If(Frac(Number) > 0, Ceil(Number, 0.5), Number) as Test1,

Ceil(Number, 0.5) as Test2;

LOAD * INLINE [

Number

1.2

1.6

];

Re: Round() function

Emmanuelle__Bustos — Fri, 22 Sep 2017 19:35:47 GMT

Thank you so much for your answer but I see that the @Sunny Talwar is a little more practice way and it solve my need.

Best regards!

Re: Round() function

Emmanuelle__Bustos — Fri, 22 Sep 2017 19:37:39 GMT

Thank you very much I see the Ceil() function is what I was looking for.

Best Regards!