topic How to Round off the percentage values? in QlikView

How to Round off the percentage values?

Wed, 19 Apr 2017 03:25:31 GMT

Hi All,

I need the below percentage values to get Roundup as 100%.

I have Tried by using Round, Floor and Ceil function .it works for 100% but 99.98 % is also turning as 100%

Requirements I need:

100.02: as 100 %

99.92: as either 99.92 or 99%

can anyone help me fixing it? so that it will be help full for my learning process

Thanks.

Muthu

Re: How to Round off the percentage values?

Anonymous — Wed, 19 Apr 2017 03:29:13 GMT

Try using Num(<your field/Expression>/100,'##.#0%')

Re: How to Round off the percentage values?

Wed, 19 Apr 2017 03:37:10 GMT

Thanks for your response Shiva.

But the above Expression is Not working

for your Exapression iam getting the Output as

But i need an out put like

100.01 % as 100%

99.98 % as either 99.98 or 99%

The Expression that I am using:

=Num((1-((Sum([Transceiver Daily Outage Duration])-Sum([Planned Downtime]))

(Sum([CPE Daily Outage Duration])+Sum([Tier1 Daily Outage Duration])))

Sum([Transceiver Daily Expected Uptime])),'#,##0.00%')

Re: How to Round off the percentage values?

hariprasadqv — Wed, 19 Apr 2017 03:54:30 GMT

Hi ,

Change the number format in Number tab of that expression.

Select Fixed and set 0 Decimal. if you are not multiplying the factor with 100 in you expression check

"Show in Percentage in the Number Tab"

Re: How to Round off the percentage values?

Wed, 19 Apr 2017 04:22:43 GMT

Thanks for your response Hari Prasad

I have checked your Logic. It is also not working

I am getting the output as 100% for all fields

even 99.98 % also getting 100%

But I need an output like

100.01 % as 100%

99.98 % as either 99.98 or 99%

Thanks,

Muthu

Re: How to Round off the percentage values?

hariprasadqv — Wed, 19 Apr 2017 04:43:42 GMT

Try ceil() or Floor()

Re: How to Round off the percentage values?

jonathandienst — Wed, 19 Apr 2017 05:24:08 GMT

I dont understand the rounding rules you want to apply. 99.98 does not round to 99, it will round to 100, and what does "either 99.98 or 99%" mean? You need one or the other.

In general,

round(x, y) will round x up or down to the nearest multiple of y. If y is omitted, use 1

ceil(x, y) will round x up to the nearest multiple of y. Likewise y defailts to 1 if omitted.

floor(x, y) will round down to the nearest multiple of y.

To produce 99.98, then use something like

=Round(99.977, 0.01)

To "round" 99.98 to 99, then use

=Floor(99.98, 1)

Similarly for 100.01

=Round(100.01, 1)

=Floor(100.01, 1)

Re: How to Round off the percentage values?

Anonymous — Wed, 19 Apr 2017 05:55:35 GMT

Use thisNum((1-((Sum([Transceiver Daily Outage Duration])-Sum([Planned Downtime]))

(Sum([CPE Daily Outage Duration])+Sum([Tier1 Daily Outage Duration])))

Sum([Transceiver Daily Expected Uptime])),'#,##0.#0%')

Re: How to Round off the percentage values?

sumitjadhav — Wed, 19 Apr 2017 06:03:21 GMT

Hi Muthu,

Try this Exppression,"Round(99.98,0.04)" if it works.

Thank's & Regards,

Sumit Jadhav.

Re: How to Round off the percentage values?

Wed, 19 Apr 2017 06:38:37 GMT

Thanks for your response Jonathan

Actually, i want

100.07 as 100%

and 99.98 % as 99.98 itself

But both I need in single column

Is there any Possibilities to get both

Re: How to Round off the percentage values?

Wed, 19 Apr 2017 06:39:35 GMT

Thanks for your response Sumit.

i have tried the expression it is not working and iam getting same result onit

Re: How to Round off the percentage values?

sumitjadhav — Wed, 19 Apr 2017 09:48:40 GMT

Hi Muthu,

Try the Below Expressions,

-->>num(Round(100.07),'###')

and

-->>Round( 99.98,0.02)

Thank's & Regards,

Sumit Jadhav.

Re: How to Round off the percentage values?

tamilarasu — Wed, 19 Apr 2017 14:07:28 GMT

Hi Muthu Kumar,

Maybe this?

Round((1-((Sum([Transceiver Daily Outage Duration])-Sum([Planned Downtime]))

(Sum([CPE Daily Outage Duration])+Sum([Tier1 Daily Outage Duration])))

Sum([Transceiver Daily Expected Uptime])),

If((1-((Sum([Transceiver Daily Outage Duration])-Sum([Planned Downtime]))

(Sum([CPE Daily Outage Duration])+Sum([Tier1 Daily Outage Duration])))

Sum([Transceiver Daily Expected Uptime]))>100,1,0.01))

Re: How to Round off the percentage values?

Fri, 21 Apr 2017 06:14:07 GMT

Thank you Jonathan