topic Re: Inner pie chart in QlikView

Inner pie chart

Wed, 26 Mar 2014 09:54:30 GMT

Hi,

I have to create a pie chart with 2 dimensions so that pie chart will have inner and outer circle and I have to display data points as well.

Here, Therapeutic Area and Disease are the dimensions.

And I want for inner circle either the value will be shown accumulated or not shown.

And I do not want to go for layering concept.

Please help.

Thanks in advance.

Re: Inner pie chart

MK_QSL — Wed, 26 Mar 2014 10:12:33 GMT

Can you provide sample data file?

Re: Inner pie chart

Wed, 26 Mar 2014 10:17:40 GMT

Hi Manish,

Re: Re: Inner pie chart

Wed, 26 Mar 2014 10:45:52 GMT

Hi Aakansha,

Might be something like attached.

Re: Re: Inner pie chart

its_anandrjs — Wed, 26 Mar 2014 10:54:27 GMT

Hi,

Take pie chart

Dimension1: Theraupatic_Area

Dimension2: Disease

Expresion :- Sum(Revenue)

and in properties -> Number -> set Fixed to 1 Decimal and select Show in Percentage%

Hope this helps

Thanks & Regards

Re: Re: Inner pie chart

Wed, 26 Mar 2014 11:04:58 GMT

Hi Anand,

I want that values which are displaying in inner circle either to add up and then shown or not shown at all, only values in outer to be dispalyed.

Re: Re: Inner pie chart

Wed, 26 Mar 2014 12:02:50 GMT

No, I want that values which are displaying in inner circle either to add up and then shown or not shown at all, only values in outer to be dispalyed

Re: Inner pie chart

Thu, 27 Mar 2014 05:32:00 GMT

So, you don't want them to be distributed on the basis of second dimension i.e. "Theraupatic Area"?

Re: Inner pie chart

Thu, 27 Mar 2014 06:13:18 GMT

Hi,

I don't want data value points of therapeutic area to be distributed as it is shown.

Re: Inner pie chart

Thu, 27 Mar 2014 06:57:57 GMT

Then instead of Theraupautic Area as a dimension, try using a calculated dimension as =Sum(TOTAL Theraupautic_Area)

Re: Inner pie chart

Thu, 27 Mar 2014 07:23:58 GMT

Hi,

I can't do sum(Therapeutic Area) as it is not a measure but a dimension.

And also i want that user can slice therapeutic area values i.e. hematology and oncology.

Just do not want data value points of therapeutic area to be distributed.

Re: Inner pie chart

Thu, 27 Mar 2014 07:55:11 GMT

Hi,

I don't think the way you want the pie chart to be displayed is possible.

As far as I know data value points can either be shown for both the dimensions or can be disabled for both.

Re: Inner pie chart

Thu, 27 Mar 2014 08:03:36 GMT

Thanks a lot for your help.