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]

its just vCurrency_1 = CND..

[sunny_talwar]

So, vCurrency_1 is a hardcoded value? It is not any field name or expression?

[Anonymous]

Month selection is disregarded but other selection like Year, Quarter ... were disregarded as well.

I just want to disregard the month selection for this KPI.

[Anonymous]

Yes, its just hardcoded..

[sunny_talwar]

You mentioned below that this ignored all selection including Month field?

If(vCurrency_1 = 'CND',

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

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

   )

Is your Month field called Month or is it month or MONTH? Because for QlikView and Qlik Sense, Month is different from MONTH and month... Qlik is case sensitive and you would want to make sure to use the correct casing of your field name.

[jmvilaplanap]

which are the values for fruit field?

[njmaehler]

Hi Arwin,

Not sure if this will help you. I have given a few scenarios.