16 Replies Latest reply: Jun 17, 2014 9:52 AM by Leni Balakrishnan

# Set Analysis

Hi All,

I have a question,

Is there a way we can disregard all selections except one. For Example, I have an application which has many fields so in that I want one of my chart to show data disregarding of all selections except the selection on currency.

Is there any way we could achieve using set analysis.?

Thanks,

Leni Balakrishnan

• ###### Re: Set Analysis

hi

Why ddidnt you try to fire trigger , and make the condition like

if(getFiledSelections(<filedName>)='currency',1,0)

• ###### Re: Set Analysis

Thank you

But this is something like I have an expression and the expression should return value disregarding of all selections in the application except on the currency field.

As my expression is something like amount*rate and the rate will be calculated based on the currency type selected.

So how it is possible to achieve using triggers??

• ###### Re: Set Analysis

hi

yes you can

it should looks something like

sum({1<Currency=Currency>}Sales)

so the 1 signals to disregard all selections , and the currency=currency implies the currency values

• ###### Re: Set Analysis

I tried but it is not working. Checked by selecting on different currency but still the value remains same

• ###### Re: Set Analysis

Hi,

Can you post your sample app.

Regards

ASHFAQ

• ###### Re: Set Analysis

Hi try below

sum({1<Currency=p(Currency)>}Sales)

Regards

ASHFAQ

• ###### Re: Set Analysis

Hi try below

sum({1<Currency=p(Currency)>}Sales)

Regards

ASHFAQ

• ###### Re: Set Analysis

Not working

• ###### Re: Re: Set Analysis

have a look

this example work perfectly

• ###### Re: Set Analysis

Thank you for the solution It worked

• ###### Re: Set Analysis

Hi,

Try something like this

Sum({<field1=,field2=,field3=,....fieldn=>}Sales)

Note :Write all the fields except currency field here as written above in the expression.

• ###### Re: Set Analysis

sum({1<Currency=p(Currency)>}Rate)*Amount

• ###### Re: Set Analysis

Hi Leni,

Find the attachment, its working.

and expression is,

Sum({1<Currency = \$::Currency>} Amount*Rate)

Regards

Khan

• ###### Re: Set Analysis

Thank you Khan It is working