topic Re: Pie Chart % Display in QlikView

Pie Chart % Display

Anonymous — Wed, 02 Dec 2015 11:25:52 GMT

Hi All,

I have a fields like Agent Number , Policy issued and Policy expired .I am using variable for calculating the eligibility % (formula is

(Policy issued)/(Policy Expired)).Now I have to draw the pie chart which has to display like in below image. The below image showing the count of agents having Eligibility % between 1-20% and 21-40% etc.. How to do this .

Please can any one help me for resolving this.

Thanks in advance

Thanks,

Anusha K

Re: Pie Chart % Display

manojkulkarni — Wed, 02 Dec 2015 11:47:08 GMT

You can do this by creating a banding column or table & link it to eligibility %. if possible provide sample data will work

Re: Pie Chart % Display

Anonymous — Wed, 02 Dec 2015 11:57:26 GMT

Hi Manoj,

PFA for sample data. In my data model Policy issued and Policy Exp are coming from two different tables.

Re: Pie Chart % Display

settu_periasamy — Wed, 02 Dec 2015 13:55:49 GMT

Hi,

May be like the attached..