topic Set Analysis question in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358706#M493318 <HTML><HEAD></HEAD><BODY><P>Hello everyone </P><P></P><P>I need a sum on a interval but the max value of the interval is going to be selected by the user. for example if i have year field going from 1997 to 2007 and the user selects 2005 I need the total of CA from 1997 to 2005. I tried every possible set Analysis expression I could think of.</P><P></P><P>Thanks in advance for your help</P></BODY></HTML> Fri, 18 May 2012 13:19:14 GMT 2012-05-18T13:19:14Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358706#M493318 <HTML><HEAD></HEAD><BODY><P>Hello everyone </P><P></P><P>I need a sum on a interval but the max value of the interval is going to be selected by the user. for example if i have year field going from 1997 to 2007 and the user selects 2005 I need the total of CA from 1997 to 2005. I tried every possible set Analysis expression I could think of.</P><P></P><P>Thanks in advance for your help</P></BODY></HTML> Fri, 18 May 2012 13:19:14 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358706#M493318 2012-05-18T13:19:14Z Re: Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358707#M493319 <HTML><HEAD></HEAD><BODY><P>Have you tried something like</P><P></P><P><EM>=sum( {&lt;Year = {"&lt;=$(=max(Year))"}&gt;} CA)</EM></P></BODY></HTML> Fri, 18 May 2012 13:27:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358707#M493319 swuehl 2012-05-18T13:27:43Z Re: Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358708#M493320 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hello,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">See the attached file. Hope it helps you.</SPAN></P></BODY></HTML> Fri, 18 May 2012 13:33:35 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358708#M493320 jagannalla 2012-05-18T13:33:35Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358709#M493321 <HTML><HEAD></HEAD><BODY><P>it does work! THANK you so much both of you for helping me, I got lost at a certain point, trying every possible expression i could think of. have a lovely weekend</P></BODY></HTML> Fri, 18 May 2012 13:44:03 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/358709#M493321 2012-05-18T13:44:03Z