topic Rounding Up... in QlikView

Rounding Up...

Wed, 12 Mar 2014 12:55:02 GMT

Hi All,

I have data which details FTE (full time equivalent) which I would like to be able to round up to FPE (full person equivalent) within QlikView expressions.

I am aware there is the "=(round(SUM(FTE))" function and I have tried a variety of alternatives [=(round(SUM(FTE),0)], but this doesn't help to round up lower figures such as 0.33 or 0.25 UP to the nearest 1 which is what I am hoping to achieve with the dataset I have.

Does anyone out there know how this can be done. If so, could you help me please?

Thanks in anticipation and regards, Mike.

Re: Rounding Up...

MK_QSL — Wed, 12 Mar 2014 13:02:06 GMT

You can use CEIL Function...

CEIL(0.35,1)

Re: Rounding Up...

ThornOfCrowns — Wed, 12 Mar 2014 13:04:11 GMT

Use CEIL(number)

Re: Rounding Up...

Wed, 12 Mar 2014 13:13:45 GMT

HI ,

You can choose CEIL() ,

PFA

Re: Rounding Up...

Wed, 12 Mar 2014 13:36:39 GMT

Hi guys,

Many thanks for your responses.

My only query is, and just out of curiosity, if I wanted to keep the 'SUM(FTE)' principle within the context of the expression principle would CEIL / FLOOR be able to accommodate this?

E.G. =CEIL(sum(FTE),0.35,1) - would this work?

If not, how can I resolve this whilst keeping the SUM(FTE) in place as this is a crucial part of what I am trying to achieve.

Thanks and regards, Mike.

Re: Rounding Up...

MK_QSL — Wed, 12 Mar 2014 13:37:36 GMT

CEIL(SUM(FTE),1)

Re: Rounding Up...

Wed, 12 Mar 2014 14:23:26 GMT

Thanks Manish! This is just what I wanted.

Regards, Mike.

Re: Rounding Up...

MK_QSL — Wed, 12 Mar 2014 14:50:43 GMT

Dear Michael,

Glad that my answer helps you.

Can you close the thread by selecting Correct Answer so that others can also get benefit of this?

Thanks .....!!