5 Replies Latest reply: Jul 26, 2012 12:03 PM by Stefan Wühl RSS

    Set Analysis

      Greetings All,

       

      CAn anyone one please help me how to write "

      =IF(Expressions='X',num(sum(Y),'# ##0')

      "

      in set analysis.

       

      Many Thanks!

        • Re: Set Analysis
          Stefan Wühl

          I just see an if-statement, no set analysis.

           

          You probably use this expression in a color attribute expression, right?

          I don't see anything wrong with the syntax itself.

           

          Is Expressions a field name or an expression label? Your expression will only work if the answer to your logical condition is unambiguous in the context you are using this expression. So it might be helpful if you tell us a bit more about this context (dimensions and expression of your chart, a bit more details about your data model). Or at best and if possible, post a small sample app.

           

          Regards,

          Stefan

            • Re: Set Analysis

              Hi Stefan,

               

              Thanks for the response.

              I have updated my query.

              Can you please tell me how to write

              IF(Expressions='Size',num(sum(pal),'# ##0')

              as set analysis.

               

              Thanks!!

                • Re: Set Analysis
                  Mayil Vahanan Ramasamy

                  HI,

                   

                       Try like this,

                   

                       =Num(Sum({<Expression= {'Size'}>} pal),'# ##0')

                   

                       Hope it helps

                    • Re: Set Analysis

                      Thanks Stefan!!

                       

                      Suppose the query is  :

                      IF(Expressions='X',num(sum(M),'# ##0'),

                                IF(Expressions = 'Y', NUM(SUM(N), '# ##0'),

                                          IF(Expressions = 'Z', NUM(SUM(O), '# ##0'),

                                                    IF(Expressions = 'A' AND MOD(k, l) = 0, 'Yes','No')

                                            )

                                  )

                      )

                       

                      How to write the above query in set analysis?

                       

                      Tx!

                        • Re: Set Analysis
                          Stefan Wühl

                          I don't think there is a way to convert this to set analysis.

                          Set analysis is like selecting values in fields, or filtering your data.

                          What I think you want to do here is not filtering the records, but applying / showing different expressions based on conditions.

                          I think you need to use conditional functions like an if-statement for that.