Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Rounding Up...

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Rounding Up...

7 Replies
Highlighted
MVP
MVP

Re: Rounding Up...

You can use CEIL Function...

CEIL(0.35,1)

Highlighted
thornofcrowns
Valued Contributor II

Re: Rounding Up...

Use CEIL(number)

Highlighted
Not applicable

Re: Rounding Up...

HI ,

You can choose CEIL() ,Rounding.png

PFA

Highlighted
Not applicable

Re: Rounding Up...

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.

Highlighted
MVP
MVP

Re: Rounding Up...

Highlighted
Not applicable

Re: Rounding Up...

Thanks Manish! This is just what I wanted.

Regards, Mike.

Highlighted
MVP
MVP

Re: Rounding Up...

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 .....!!