Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display a % on a pie chart?

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

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

1st : avg(F1)

2nd : 100-avg(F1)

View solution in original post

5 Replies
giakoum
Partner - Master II
Partner - Master II

Please see attached.

two expressions used.

Generally I am against pie charts...

Not applicable
Author

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
Partner - Master II
Partner - Master II

1st : avg(F1)

2nd : 100-avg(F1)

MayilVahanan

Hi,

     Try this,

      -No dimension

     Use too expression like this,

   

     1.Avg(Field)

     2.100 - Avg(Field)

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Yes that works a treat. Much appreciated Ioannis!