Set Analysis

[#1]

Greetings All,

CAn anyone one please help me how to write "

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

"

in set analysis.

Many Thanks!

[swuehl]

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

[#3]

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!!

[MayilVahanan]

HI,

     Try like this,

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

     Hope it helps

[#5]

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!

[swuehl]

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.