topic Re: Set analysis - ignore ALL the selection in App Development

Set analysis - ignore ALL the selection

TIGERMG — Thu, 11 May 2023 09:03:24 GMT

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 :

Re: Set analysis - ignore ALL the selection

Chanty4u — Thu, 11 May 2023 09:14:24 GMT

Try this

vIgnoreSelections = 'ACTUALS'

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

Re: Set analysis - ignore ALL the selection

Chanty4u — Thu, 11 May 2023 09:14:52 GMT

Or may be

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

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

)

Re: Set analysis - ignore ALL the selection

BrunPierre — Thu, 11 May 2023 09:31:49 GMT

Have you tried?

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

Re: Set analysis - ignore ALL the selection

TIGERMG — Thu, 11 May 2023 09:36:46 GMT

HI BrunPierre,

I tried this but not working.

Re: Set analysis - ignore ALL the selection

TIGERMG — Thu, 11 May 2023 09:37:16 GMT

HI Chanty4u,

I tried both this but not working.

Re: Set analysis - ignore ALL the selection

Chanty4u — Thu, 11 May 2023 09:59:19 GMT

May be try this

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

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

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

sum({<ACTUALS=>} VALUE)

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

Re: Set analysis - ignore ALL the selection

tresB — Thu, 11 May 2023 10:12:38 GMT

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')

Re: Set analysis - ignore ALL the selection

TIGERMG — Tue, 16 May 2023 06:47:06 GMT

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)