Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Re: How to Round off the percentage values?

Thanks for your response Sumit.

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

sumitjadhav
Contributor II

Re: How to Round off the percentage values?

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?

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))

Not applicable

Re: How to Round off the percentage values?

Thank you Jonathan