topic Re: Round Percentage in QlikView

Round Percentage

marco_puccetti — Mon, 15 Jun 2015 12:33:36 GMT

Hello i need to round a percentage value from

nn.n1n2n3n4n5n6 to nn.n1 which function can i use?

The formula used is the following:

=num(count(distinct value1),'#,##0.##','.' , ',') / num(Count(distinct value2),'#,##0.##','.' , ',') * 100 & '%'

Thanks

Marco

Mon, 15 Jun 2015 12:35:56 GMT

Do you just need the displayed format to be to 1 decimal place?

avinashelite — Mon, 15 Jun 2015 12:39:40 GMT

add this in num

'###,###,###.##0,00'

num(count(distinct value1),'#,##0.##0,00','.' , ',') / num(Count(distinct value2),'#,##0.##0,00','.' , ',') * 100 & '%'

Thanks

marco_puccetti — Mon, 15 Jun 2015 12:49:09 GMT

It doesn't work!

How can i force the 2 decimal value?

Thanks

Marco

tresB — Mon, 15 Jun 2015 12:54:21 GMT

Num(12.34567, '##.##') - for two possible decimal

Num(12.34567, '##.00') - for forced two decimal

marco_puccetti — Mon, 15 Jun 2015 12:57:50 GMT

Yes i've just tried with Num(123456.789789789,'##.##') and it works.

Thanks

Marco

alex_millan — Mon, 15 Jun 2015 12:58:49 GMT

Hi,

and perhaps you may want to force the desired format (two decimal values) on the division result

= num( ( [Expression A] / [Expression B] ) * 100, '##,00' ) & '%'

HTH

Regards