topic Percentage in Block Chart in QlikView

Percentage in Block Chart

Anonymous — Wed, 22 Feb 2012 21:19:28 GMT

Hello,

I have this block chart, and I have a section called OTHERS, well, in each section different from others I have my percentage. But the OTHERS section gives me a decimal number. How can I make that OTHERS section percentage?

I attach two images that could be helpful.

Percentage in Block Chart

Sokkorn — Thu, 23 Feb 2012 03:45:00 GMT

Hi,

Let try this expression: NUM(COUNT(DISTINCT {<>} ID) / COUNT(DISTINCT {<>} TOTAL ID),'###.00%')

Regards,

Sokkorn Cheav

Re: Percentage in Block Chart

CELAMBARASAN — Thu, 23 Feb 2012 04:40:53 GMT

Hi,

Try by check the Relative option in the expression tab.

check with the attached image.

Re: Percentage in Block Chart

Anonymous — Thu, 23 Feb 2012 13:42:46 GMT

Hello,

as ID do you mean Id_autorizacion?

and what should I insert between the {<>} marks?

Percentage in Block Chart

jagan — Thu, 23 Feb 2012 13:56:59 GMT

Hi,

Try the following expression

=NUM(COUNT(DISTINCT ID) / COUNT(DISTINCT TOTAL ID),'###.00%')

Regards,

Jagan.

Re: Percentage in Block Chart

Anonymous — Thu, 23 Feb 2012 14:10:21 GMT

Hello, I've done that, but the group OTHERS keep showing as a decimal number, it doesn't matter if I check Relative Option.

The other values are showing as percentage. All I want to know is what percentage correspond to OTHERS group.

Look what I got OTHERS = Otros (the aggrupation that QV make with a bunch of data), that's the one I don't understand the problem with the percentage.