topic Re: % issue in Pie chart in QlikView

% issue in Pie chart

Wed, 10 Sep 2014 12:31:12 GMT

Hi Qv,

How can I show % in pie chart out of 100%.

Please find attached, In my chart I have 1 dimension and 1 expr and expr is :

sum({<Segment={'Group'}>}[Room Revenue])/1000000

Dimension : End user direct/Third party.

Here I'm trying to show the % out of 100%, but it is showing like in the attached image.

So my requirement is, the chart should show

End user accounts - 46%

Third party - 54%.

Thanks,

Ananth

amit_saini — Wed, 10 Sep 2014 12:33:32 GMT

Ananth,

You can click on the "Relative" checkbox.

This option is available under expression tab.

Thanks,

israrkhan — Wed, 10 Sep 2014 12:34:34 GMT

try this

check value on data point for the expression

Wed, 10 Sep 2014 12:35:34 GMT

Oh my God, How much simple it is.

ThanQ Amit for your quick reply.

amit_saini — Wed, 10 Sep 2014 12:37:57 GMT

it is

Cheers!