Set Analysis - Ignore a selection

[Anonymous]

Hi,

Would like to create a set analysis that would ignore a selection, but this won't work. Any idea what the problem is?

If(Fruits = 'Red',

     Sum({$< Fruits = {'Red'}, Apple >}Sweet),

         Sum({$< Fruits = {'Green'}, Apple >}Sweet)

   )

I'd like to ignore the field of Apple.

[Anonymous]

Can't share the app as it contains confidential data.. Is there any form of set analysis that would give me the same result?

[big_dreams]

Apple is fieldName or value in table?

If it is value then it come under which field ?

If you want to show sum of sweet where Fruit is Red or Green.

then just use

sum({<Fruits={'Red','Green'}>}Sweet)

Regards,

[tresesco]

Check this: Preparing examples for Upload - Reduction and Data Scrambling

[vijetas42]

First check value of your variable vCurrency_1 that, are you getting selected value (CND or USD) in it?

If(vCurrency_1 = 'CND',

Sum({<Currency = {'CND'},Month>}Budget),

    Sum({<Currency = {'USD'},Month>}Budget)

   )

[Anonymous]

It's selected to CND.. All were correct but I just want to disregard the month selection..

[sunny_talwar]

How do you define vCurrency_1? is this an expression? Are you ignoring selection in Month field for the expression behind vCurrency_1?

[sudhirpkuwar]

Its working fine at my end

check this if you can find it useful

[vijetas42]

Can you please provide expression that you have wrote for vCurrency_1

[sasiparupudi1]

If(vCurrency_1 = 'CND',

Sum({1<Currency = {'CND'},Month>}Budget),

    Sum({1<Currency = {'USD'},Month>}Budget)

   )

[Anonymous]

Its just vCurrency_1 = CND