5 Replies Latest reply: Aug 16, 2012 10:00 AM by dtringaqlink RSS

    Chart: Problem with Total (sum) in Expression

      Hello everyone,

      I have a chart that looks like this one:

       

      start_chart.bmp

      I would like to have another chart line displaying the total of all current lines, to achieve this:

       

      Desired_Chart.JPG

      However when i try to add a new expression with the total using this Set Analysis

       

      SUM({$ <Life = {"*"} >} ExtGSV$)

       

      It seems it removes the other 4 lines and i am left with this result, only total is displayed:

      Result_Chart.JPG

       

      Please help me, i have attached an example to better understand.

       

      thanks a lot in advance for your attention and help.

        • Re: Chart: Problem with Total (sum) in Expression
          Wojciech Parzyszek

          the first chart on the qvw file (att by you) is exacly what you are asking for

           

          isn't it?

           

          i cant find the problem you've got:/

            • Re: Chart: Problem with Total (sum) in Expression

              thanks for your reply Pari,

               

              the first chart is what i am after. see below:

              wanted_chart.JPG

              but it was created limiting each line using a separate expression using the following

               

              for the total:

              SUM({$ <Life = {"*"} >} ExtGSV$)

              for each line:

              Sum({$ <Life = {'A(<50%)'} >}ExtGSV$)

              Sum({$ <Life = {'B(50-70%)'} >}ExtGSV$)

              Sum({$ <Life = {'C(70-85%)'} >}ExtGSV$)

              Sum({$ <Life = {'D(>85%)'} >}ExtGSV$)

               

              however doing it this way it will not be possible to drill-down clicking on each line and this is a problem.

               

              I would like to be able to obtain the same result using a single expression to display the 4 lines for (LIFE) using this Sum(ExtGSV$)

              and add another expression for the total. i have tried using SUM({$ <Life = {"*"} >} ExtGSV$) but as mentioned it doesn't work.

              In my example on the second bottom chart if you disable the first expression (Total GSV$) you will see the 4 lines appear correctly but when i try to get the 5th line with the total it doesn't work.

               

              hope you can better understand me.

              thanks

               

                • Re: Chart: Problem with Total (sum) in Expression
                  Wojciech Parzyszek

                  you did't say you want to drill down before:)

                  if you want to drill down you should prepare group dimension

                   

                  you wrote:

                   

                  "

                  for the total:

                  SUM({$ <Life = {"*"} >} ExtGSV$)

                  for each line:

                  Sum({$ <Life = {'A(<50%)'} >}ExtGSV$)

                  Sum({$ <Life = {'B(50-70%)'} >}ExtGSV$)

                  Sum({$ <Life = {'C(70-85%)'} >}ExtGSV$)

                  Sum({$ <Life = {'D(>85%)'} >}ExtGSV$)

                   

                  however doing it this way it will not be possible to drill-down clicking on each line and this is a problem.

                   

                  "

                   

                  can you answer what you want to see after "drill-down clicking on each line"?

                    • Re: Chart: Problem with Total (sum) in Expression

                      clicking on each line should create an equivalent of a selection and therefore if i click on one line will filter/display data in other objects based on the selection. For example if i click on the green line it shall filter by 'Life D(>85%)'.

                      If i use the following as in my example won't work.

                       

                      for the total:

                      SUM({$ <Life = {"*"} >} ExtGSV$)

                      for each line:

                      Sum({$ <Life = {'A(<50%)'} >}ExtGSV$)

                      Sum({$ <Life = {'B(50-70%)'} >}ExtGSV$)

                      Sum({$ <Life = {'C(70-85%)'} >}ExtGSV$)

                      Sum({$ <Life = {'D(>85%)'} >}ExtGSV$)

                       

                      thanks

                • Re: Chart: Problem with Total (sum) in Expression
                  Wojciech Parzyszek

                  image 2

                   

                  only looks like the expression is missing (becouse the expression generate the same result)

                   

                  check it by changing this chart from line chart to straight table