topic Re: SET ANALYSIS in QlikView https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230740#M392214 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum({&lt;YearMonth={$(<SPAN style="color: #ff0000;">='&gt;' &amp;</SPAN> Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))}<SPAN style="color: #ff0000;">&gt;}</SPAN> COMPONENTVALUE)</STRONG></P></BODY></HTML> Sun, 05 Mar 2017 12:03:31 GMT sunny_talwar 2017-03-05T12:03:31Z SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230737#M392211 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I need to creat this expression-</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">YearMonth</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))</EM></STRONG><SPAN style="font-size: 8pt;">}</SPAN><SPAN style="color: #800000; font-size: 8pt;">COMPONENTVALUE</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">This expression work good</SPAN></P><P><SPAN style="font-size: 8pt;">but i need not when <SPAN style="color: #800000; font-size: 8pt;">YearMonth = <STRONG><EM style="color: #808080;">Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))</EM></STRONG></SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><STRONG><EM style="color: #808080;">i need that <SPAN style="color: #800000; font-size: 8pt;">YearMonth <SPAN style="color: #0000ff;"><SPAN style="font-size: 14pt;">&gt;</SPAN> <SPAN style="color: #800000;"><STRONG><EM style="color: #808080;">Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))</EM></STRONG></SPAN></SPAN></SPAN></EM></STRONG></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><STRONG></STRONG></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><STRONG><EM style="color: #808080;">how should i do it?</EM></STRONG></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><STRONG></STRONG></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><STRONG><EM style="color: #808080;">adi</EM></STRONG></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><STRONG></STRONG></SPAN></P></BODY></HTML> Sun, 05 Mar 2017 11:32:19 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230737#M392211 adiarnon 2017-03-05T11:32:19Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230738#M392212 <HTML><HEAD></HEAD><BODY><P>See this:</P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Sun, 05 Mar 2017 11:56:47 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230738#M392212 ecolomer 2017-03-05T11:56:47Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230739#M392213 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">YearMonth</SPAN><SPAN style="font-size: 8pt;">={<SPAN style="color: #ff0000;">"&gt;</SPAN></SPAN><SPAN style="color: #808080; font-size: 8pt;"><STRONG><EM>$(=Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))<SPAN style="color: #ff0000;">"</SPAN></EM></STRONG></SPAN><SPAN style="font-size: 8pt;">} &gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">COMPONENTVALUE</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P></BODY></HTML> Sun, 05 Mar 2017 11:59:06 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230739#M392213 Anonymous 2017-03-05T11:59:06Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230740#M392214 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum({&lt;YearMonth={$(<SPAN style="color: #ff0000;">='&gt;' &amp;</SPAN> Date(AddYears(MakeDate(max(Year),max(Month),1),-1),'YYYYMM'))}<SPAN style="color: #ff0000;">&gt;}</SPAN> COMPONENTVALUE)</STRONG></P></BODY></HTML> Sun, 05 Mar 2017 12:03:31 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230740#M392214 sunny_talwar 2017-03-05T12:03:31Z Re: SET ANALYSIS https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230741#M392215 <HTML><HEAD></HEAD><BODY><P>Alternatively, why not just this?</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Sum({&lt;YearMonth={$(<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">='&gt;' &amp;</SPAN> Date(AddYears(<SPAN style="color: #ff0000;">Max(YearMonth), -1)</SPAN>, 'YYYYMM'))}<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">&gt;}</SPAN> COMPONENTVALUE)</STRONG></P></BODY></HTML> Sun, 05 Mar 2017 12:05:26 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS/m-p/1230741#M392215 sunny_talwar 2017-03-05T12:05:26Z