topic Re: Pie Chart with extra text in Chart in QlikView

Pie Chart with extra text in Chart

Sat, 29 Nov 2014 06:40:56 GMT

Dear All,

i am creating a Pie Chart on Turnover ( T/O in Cr.) basis, but in pie chart i want to added some extra expression TEXT within the PIE.

The Example file is attached below.

Kindly help

Thanks & Regards,

Jitendra Vishwakarma.

Re: Pie Chart with extra text in Chart

its_anandrjs — Sat, 29 Nov 2014 06:48:38 GMT

Hi,

You can use option in the chart properties >> Expressions >> select the expression and (Values on Data Points and Text as Pop-up and tick mark that options.

Regards

Anand

Re: Pie Chart with extra text in Chart

Sat, 29 Nov 2014 07:06:49 GMT

Dear Anand,

You did not understand my requirement. the pie chart will create on T/O basis only and top of it i want this count information in the pie chart area permanent ( not as pop-up)

Re: Pie Chart with extra text in Chart

maxgro — Sat, 29 Nov 2014 07:19:02 GMT

like this? if yes use dual in expression

Re: Pie Chart with extra text in Chart

Sat, 29 Nov 2014 07:31:41 GMT

No. this is also not my requirement, my requirement is:

i have a table with straigh table with one Dimension "Order Type"

and two expression 1 : No. of Members

2 : Turnover ( T/O)

Now my requirement is :

i want to create a PIE Chart on basis of Dimension "Order Type" and Expression "Turnover" only. ( This is fine no Issue on this) .

After all this now my requirement is on each "Order Type" there is one more expression i.e. "No. of Members".

Now this Expression i want to put in the Pie chart.. ( Note:. Pie will remain created on basis of "Turnover". the "No. of Member" expression is addition information which i want in the PIE Chart as a plain TEXT

Re: Pie Chart with extra text in Chart

Sat, 29 Nov 2014 07:46:22 GMT

Dear All,

Please find attached Image for understanding my requirement.

if you closely then you will found that the pie chart is make on basis of T/O only, but the numeric is coming from the count Column.

Re: Pie Chart with extra text in Chart

maxgro — Sat, 29 Nov 2014 07:47:42 GMT

you can put no of members in the text part of the expression or another expression...whatever you want; in the number part use turnover

Dual(Sum(NoOfMember),Sum (Turnover))

The problem could be if you want the NoOfMember inside the pie and not outside

See attachment

Re: Pie Chart with extra text in Chart

Mon, 01 Dec 2014 07:05:33 GMT

its working.. just you have to ensure that in number tag you have to select format as 'Default Expression"

Thanks,

Jitendra Kumar Vishwakarma