topic Set Analysis and Quarter selection?!?! in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-and-Quarter-selection/m-p/144695#M23546 <HTML><HEAD></HEAD><BODY><P>All - I am trying to get set analysis to give me all 3 mos in any given quarter, no matter what month is selected in a given range...</P><P>I have been using</P><P><I></I><I></I></P><P></P><P>sum</P><P></P><P></P><P>({$&lt;Year = {<B><I>$(=max(Year))</I></B>}, Quarter = {<B><I>$(=MaxString({&lt;Year={$(=max(Year))}&gt;} Quarter))</I></B>}, Month = {"&lt;=$(=max({&lt;Year={$(=max(Year))}&gt;} Month))"}&gt;} Goal</P><P>)</P><P>But this only gives you the max mos for the selected range, ie if you select may and june you would have 2 mos in your result not the 3</P><BR /><BR /> <BR /><BR /> <P>For example, if you have 2009 selected, and select the month of March, you should obtain Jan, Feb and March or Q1 as a result. If you select Jan, Feb, Mar Apri, you should expect to see (April May and June) or Q2</P><P>If you select Sep, Oct and Nov, you should expect to see Oct, Nov and Dec or Q4...</P></BODY></HTML> Fri, 22 May 2009 09:51:42 GMT james 2009-05-22T09:51:42Z Set Analysis and Quarter selection?!?! https://community.qlik.com/t5/QlikView/Set-Analysis-and-Quarter-selection/m-p/144695#M23546 <HTML><HEAD></HEAD><BODY><P>All - I am trying to get set analysis to give me all 3 mos in any given quarter, no matter what month is selected in a given range...</P><P>I have been using</P><P><I></I><I></I></P><P></P><P>sum</P><P></P><P></P><P>({$&lt;Year = {<B><I>$(=max(Year))</I></B>}, Quarter = {<B><I>$(=MaxString({&lt;Year={$(=max(Year))}&gt;} Quarter))</I></B>}, Month = {"&lt;=$(=max({&lt;Year={$(=max(Year))}&gt;} Month))"}&gt;} Goal</P><P>)</P><P>But this only gives you the max mos for the selected range, ie if you select may and june you would have 2 mos in your result not the 3</P><BR /><BR /> <BR /><BR /> <P>For example, if you have 2009 selected, and select the month of March, you should obtain Jan, Feb and March or Q1 as a result. If you select Jan, Feb, Mar Apri, you should expect to see (April May and June) or Q2</P><P>If you select Sep, Oct and Nov, you should expect to see Oct, Nov and Dec or Q4...</P></BODY></HTML> Fri, 22 May 2009 09:51:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Quarter-selection/m-p/144695#M23546 james 2009-05-22T09:51:42Z