how to write this in set analysis

[ali_hijazi]

Hello

I want to get the maximum phase number that is common in the current selection set of data and the set of data where season = last year's season

Ok

the user selects current season say it is 122 then last year's season is 112

max(PhaseNo) gives 1

max({<Season={$(vLastYearSeason)}>} PhaseNo) gives 5

knowing that $(vLastYearSeason) is 112

and if I put PhaseNo is a list box then when season is 122 then I have only Phase 1 in white

whereas when season is 112 i have phase 1 to phase 5 in white

Please advise

[sujeetsingh]

use set modifier $1 for previous selection.

[ali_hijazi · Accepted solution]

I solved it this way

I created a variable with the following definition

=max(PhaseNo)

and let's say I gave it a name newVariable...

then I modified the expression as follows:

max({<Season={$(vLastYearSeason)}> * $} if(PhaseNo<=$(newVariable),PhaseNo))