5 Replies Latest reply: Apr 16, 2012 2:12 PM by Logesh Jayaraman RSS

    Expression

    Logesh Jayaraman

      Hi,

       

      I am trying to use the output of the expression as the input to calculation of another expression.It is showing as '-'  . Attached the example for your reference.

        • Re: Expression
          Logesh Jayaraman

          Sorry attached the Example now

            • Re: Expression

              From the QV Manual: "dimensionality ( ) returns the number of dimension columns that have non-aggregation
              content, i.e. do not contain partial sums or collapsed aggregates." So, you I don't think you need the avg() statement as it is reporting the number of dimensions, which would always be the same for all rows. You can use 'if' statements to derive data based on the value returned. The manual said it is typically used for conditional formatting. What are you trying to achieve?

                • Re: Expression
                  Logesh Jayaraman

                  Thanks for your response.

                   

                  I am looking forward to show the max value of the Expandeddimension column as the additional column is there any way around

                    • Re: Expression

                      So, basically you want to know the number of possible dimensions, not the number currently expanded dimensions (which is what dimensionality() returns)?

                        • Re: Expression
                          Logesh Jayaraman

                          Not exactly  Ideally i want to show the expanded number of dimensions. If i expand manually the two dimension it dimensionality will show 2 for the row  with dimension expanded and others for 1 where dimension is not expanded. I want to add the additonal column with all rows having the same value as the max(Dimensionality) or it can be like i need to store the max (dimensionality()) in a variable.