topic Convert to a Percent - Text Object in QlikView

Convert to a Percent - Text Object

ivandrago — Fri, 26 Nov 2010 13:48:19 GMT

Hi,

I have the below formula which is in a Text Box but I want the result to be in a pecentage and in 2 decimal places i.e. 98.53%, Tried using the function num, but wasn't working and not sure if I was doing it the right way?

=1-(count({1<[Type]={'EXPECTED'}>} DISTINCT [ID])
/count({1<[Type]={'EXPECTED'}, [LP Flag]={0}>} DISTINCT [ID]))

Thanks

Convert to a Percent - Text Object

Miguel_Angel_Baeyens — Fri, 26 Nov 2010 13:57:42 GMT

Hello,

Giving the Num() function a format should work

=Num(1-(count({1<[Type]={'EXPECTED'}>} DISTINCT [ID])/count({1<[Type]={'EXPECTED'}, [LP Flag]={0}>} DISTINCT [ID])), '#.##0,#0 %')

Note that in the format part I'm using "," as decimal separator and "." as thousand separator, and you may want to change that.

Hope this helps

Convert to a Percent - Text Object

deepakk — Fri, 26 Nov 2010 13:58:30 GMT

hi,

use num function

num(1-(count({1<[Type]={'EXPECTED'}>} DISTINCT [ID])

/count({1<[Type]={'EXPECTED'}, [LP Flag]={0}>} DISTINCT [ID])) ,'#0.00%')

Convert to a Percent - Text Object

deepakk — Fri, 26 Nov 2010 14:00:25 GMT

Hi,

Me and Miguel pressed the post button at the same time.. and I lost by a fraction of seconds..

Convert to a Percent - Text Object

Fri, 26 Nov 2010 14:11:13 GMT

Yes,

it is always the same with Miguel.

Looking forward to the weekend,

Roland