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

# Set Analysis

Greetings All,

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

"

in set analysis.

Many Thanks!

• ###### Re: Set Analysis

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

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

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.