topic Re: Show field values in a pie chart in QlikView

Show field values in a pie chart

Wed, 16 Jul 2014 08:53:45 GMT

Hey guys,

would it be possible to show values of a field in a pie chart and calculate the proportion of each unique field value, even though there is no another table for those values being identified?

Best regards and many thanks!

Re: Show field values in a pie chart

avinashelite — Wed, 16 Jul 2014 08:58:17 GMT

Can you please post the test app.

Re: Show field values in a pie chart

Wed, 16 Jul 2014 08:59:09 GMT

Yes this is possible. Could you pl paste the screenshot.

Re: Show field values in a pie chart

Wed, 16 Jul 2014 09:09:37 GMT

Hey Avinash and Subhranjali,

thank you for your responses.

For example I have a table column type with field values like:

type

I would like to to show the proportion of the value "a", "b", and "c" in a pie chart, which should be in this case 33.3%, 33.3%, and 33.3%

and I don't have another table in the database for identifying "a", "b", and "c"

Re: Re: Show field values in a pie chart

avinashelite — Wed, 16 Jul 2014 09:19:47 GMT

Hi Myriadius,

Please find the attachment for the solution.

Note: After writing the expression go to numbers and select show in %.

Regards,

@vi

Re: Show field values in a pie chart

sudeepkm — Wed, 16 Jul 2014 09:29:53 GMT

you can show values on the PIE chart data points or in the legends (in case the chart is busy).

For % you can also try enabling "relative" in Expressions. Please take a look at the screenshot below.

Re: Show field values in a pie chart

Wed, 16 Jul 2014 10:41:50 GMT

Thank you all a lot!