topic text on a pie chart in QlikView

text on a pie chart

Thu, 29 Sep 2011 14:44:45 GMT

Hi,

I've a problem with pie chart. I want to show on the pie chart pie at the same time the value and the text legend. I don't wanto to show on the pie chart only the values and on the right or left side of the chart the text legend.

How can I do?

Thanks in advanced.

text on a pie chart

its_anandrjs — Thu, 29 Sep 2011 14:50:16 GMT

Hi,

Select value on data point option by selecting expression

Rgds

Anand

Re: text on a pie chart

sridhar240784 — Thu, 29 Sep 2011 14:52:24 GMT

If i unsderstand your question properly,

Go to Chart Property--> Presentation--> Check Show Numbers in Legend and Show Legeds

and

Go to Expression Tab and uncheck 'Show Value on Data Point' option.

-Sridhar

text on a pie chart

its_anandrjs — Thu, 29 Sep 2011 14:58:28 GMT

Hi,

Select Presentation -> Show Legend -> Checked Show Numbers in legend.

Rgds

Anand

text on a pie chart

Thu, 29 Sep 2011 15:36:21 GMT

Hi,

thank you for the answer, but the solutions that you said doesn't function.

In attached you can see an image of the output the I need.

Thanks,

Re: text on a pie chart

sridhar240784 — Thu, 29 Sep 2011 16:07:17 GMT

Check out the attached application.

Hope this helps you.

-Sridhar

text on a pie chart

Tue, 04 Oct 2011 10:52:22 GMT

Hi,

Thank you for your advice. the dual expression function very good; but now I want to make the same notation using the percentage.

I use the dual expression in this way, but it doesn't work and I don't know why, could you help me?

dual(

(COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)/

(

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antibiotico)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_betametasone)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_idratazione_E_V)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_MGSO4)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_tocolisi))

) &'-'& 'Anti ipertensivo',

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)/

(

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antibiotico)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_betametasone)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_idratazione_E_V)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_MGSO4)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_tocolisi))

)

thanks in advance.

Re: text on a pie chart

sridhar240784 — Wed, 05 Oct 2011 06:37:45 GMT

Hi,

Try this below expression. Before concatenating the string with expression, enclose the expression with brackets. You are concatenating the string with expression and this making the whole denominator as string. So Qlikview tries to divide the Number by string and you are getting 'No data Displayed' in your charts. Try this below expression. Hope this helps you

Dual((

(COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)/

(

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antibiotico)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_betametasone)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_idratazione_E_V)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_MGSO4)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_tocolisi))

)) &'-'& 'Anti ipertensivo',

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)/

(

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antibiotico)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_antipertensivo)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_betametasone)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_idratazione_E_V)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_MGSO4)+

COUNT({$<As_transfer_reason_category={2}>} Ds_taken_terapy_tocolisi))

)

-Sridhar