topic Re: Display a % on a pie chart? in QlikView

Display a % on a pie chart?

Mon, 02 Jul 2012 14:33:22 GMT

Hi all,

I have an average calculated in an expression which outputs a percentage:

=Avg(field)

I do not have a dimension in this particular case. How can I have a pie chart that represents this value?

For example, sayy the average is 39%, so I want the pie chart to show 39% as one colour and the other 61% as another colour.

So far the pie chart is all one colour with the value of 39.

Any ideas?

Regards

Revlin

giakoum — Mon, 02 Jul 2012 14:38:33 GMT

Please see attached.

two expressions used.

Generally I am against pie charts...

Mon, 02 Jul 2012 14:43:09 GMT

Hi Ioannis

Unfortunately I am currently using the personal edition, so I can not open your file.

Would you be able to paste the expressions?

giakoum — Mon, 02 Jul 2012 14:44:47 GMT

1st : avg(F1)

2nd : 100-avg(F1)

MayilVahanan — Mon, 02 Jul 2012 14:46:46 GMT

Hi,

Try this,

-No dimension

Use too expression like this,

1.Avg(Field)

2.100 - Avg(Field)

Hope it helps

Mon, 02 Jul 2012 14:49:39 GMT

Yes that works a treat. Much appreciated Ioannis!