topic Re: expression in QlikView

expression

Fri, 24 Jan 2014 15:53:54 GMT

Hi,

Got the following expression which works but comes out as 0.48% when the answer should be 48%. The two figures are 1144 and 2296.

Can anyone help?

Num(Count([Tenant_Arrears])/Count([Address]), '%##.##')

Cheers

Chris

Fri, 24 Jan 2014 15:56:38 GMT

Hi Chris

the best would be not to use NUM function but set your result to % in "numbers" tab

best regards

Chris

MK_QSL — Fri, 24 Jan 2014 15:58:20 GMT

Num(Count([Tenant_Arrears])/Count([Address]), '##.##0%')

rustyfishbones — Fri, 24 Jan 2014 15:59:34 GMT

Hi Chris,

try like this

Num(Count([Tenant_Arrears])/Count([Address]), '#,##0%')

Fri, 24 Jan 2014 16:00:27 GMT

you can try:

Num(Count([Tenant_Arrears])/Count([Address]), '%##.##') *100