7 Replies Latest reply: Oct 5, 2011 2:37 AM by Sridhar Ethiraj RSS

    text on a pie chart

      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
          Anand Chouhan

          Hi,

           

          Select value on data point option by selecting expression

           

          Rgds

          Anand

          • Re: text on a pie chart
            Sridhar Ethiraj

            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
              Anand Chouhan

              Hi,

               

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

               

              Rgds

              Anand

              • text on a pie chart

                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,examplePieChart.jpg

                  • Re: text on a pie chart
                    Sridhar Ethiraj

                    Check out the attached application.

                     

                    Hope this helps you.

                     

                    -Sridhar

                      • text on a pie chart

                        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
                            Sridhar Ethiraj

                            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