topic Re: how to write this in set analysis in QlikView https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438717#M163529 <HTML><HEAD></HEAD><BODY><P>use set modifier $1 for previous selection.</P></BODY></HTML> Wed, 08 May 2013 11:47:52 GMT sujeetsingh 2013-05-08T11:47:52Z how to write this in set analysis https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438716#M163528 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>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</P><P>Ok</P><P>the user selects current season say it is 122 then last year's season is 112</P><P>max(PhaseNo) gives 1</P><P>max({&lt;Season={$(vLastYearSeason)}&gt;} PhaseNo) gives 5</P><P></P><P>knowing that $(vLastYearSeason) is 112</P><P>and if I put PhaseNo is a list box then when season is 122 then I have only Phase 1 in white</P><P>whereas when season is 112 i have phase 1 to phase 5 in white</P><P></P><P></P><P>Please advise</P></BODY></HTML> Wed, 08 May 2013 11:42:01 GMT https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438716#M163528 ali_hijazi 2013-05-08T11:42:01Z Re: how to write this in set analysis https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438717#M163529 <HTML><HEAD></HEAD><BODY><P>use set modifier $1 for previous selection.</P></BODY></HTML> Wed, 08 May 2013 11:47:52 GMT https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438717#M163529 sujeetsingh 2013-05-08T11:47:52Z Re: how to write this in set analysis https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438718#M163530 <HTML><HEAD></HEAD><BODY><P>I solved it this way</P><P>I created a variable with the following definition</P><P>=max(PhaseNo) </P><P>and let's say I gave it a name newVariable...</P><P></P><P>then I modified the expression as follows:</P><P>max({&lt;Season={$(vLastYearSeason)}&gt; * $} if(PhaseNo&lt;=$(newVariable),PhaseNo))</P></BODY></HTML> Thu, 09 May 2013 07:43:29 GMT https://community.qlik.com/t5/QlikView/how-to-write-this-in-set-analysis/m-p/438718#M163530 ali_hijazi 2013-05-09T07:43:29Z