Set analysis - ignore ALL the selection

[TIGERMG]

Hi ALL,

Is it possible to ignore all the selection in set analysis?

Set Expression :        sum({<ACTUALS={'$(vTest1)'}>}VALUE)

                                        sum({<ACTUALS={'$(vTest2)'}>}VALUE)

variable

vTest1  = date(AddMonths(Max({<CATEGORY={'A'}>}DATE),0),'MMM-YY') = MAY 23

vTest2  = date(AddMonths(Max({<CATEGORY={'A'}>}DATE),-1),'MMM-YY') = APR 23

I have one field CATEGORY with A and B so i created filter like  = if(CATEGORY='A',DATE) as ACTUALS so in this i have only the date which is belongs to CATEGORY='A'. 

I want if i select anything in ACTUALS  filters it will not affect on my above Set Expression :

[Chanty4u]

Try this 

vIgnoreSelections = 'ACTUALS'

sum({$<ACTUALS -= {'$(vIgnoreSelections)'}>} VALUE)

[Chanty4u]

Or may be

sum({<$ACTUALS={'$(vTest1)'}>} VALUE)

sum({<$ACTUALS={'$(vTest2)'}>} VALUE

)

[BrunPierre]

Have you tried?

sum({1<ACTUALS={'$(vTest1)'}>}VALUE)
sum({1<ACTUALS={'$(vTest2)'}>}VALUE)

[TIGERMG]

HI BrunPierre,

I tried this but not working.

[TIGERMG]

HI Chanty4u,

I tried both this but not working.

[Chanty4u]

May be try this 

sum({<ACTUALS={'*'}>} VALUE)

Or

sum({<ACTUALS = {'1'}>} VALUE)

Or 

sum({1<ACTUALS = {'$(=ACTUALS)'}>} VALUE)

Or 

sum({<ACTUALS=>} VALUE)

Or 

sum({<ACTUALS = {'=1'}>} VALUE)

[tresesco]

Since you are using an aggregation function in variable definition, you have to use the set analysis there too for selection ignorance. Try like:

vTest1  = date(AddMonths(Max({<ACTUALS, CATEGORY={'A'}>}DATE),0),'MMM-YY') 

vTest2  = date(AddMonths(Max({<ACTUALS, CATEGORY={'A'}>}DATE),-1),'MMM-YY') 

[TIGERMG · Accepted solution]

Hi ALL<

vTest1  = date(AddMonths(Max({1< CATEGORY={'A'}>}DATE),0),'MMM-YY') 

vTest2  = date(AddMonths(Max({1< CATEGORY={'A'}>}DATE),-1),'MMM-YY') 

and also need to apply in set expression 

sum({1<ACTUALS={'$(vTest1)'}>}VALUE)