topic SetAnalisis in QlikView https://community.qlik.com/t5/QlikView/SetAnalisis/m-p/232227#M83871 <HTML><HEAD></HEAD><BODY><P style="MARGIN: 0cm 0cm 0pt">I have to bring all businesses in the current year that were open last year and businesses that the month previous year did not sell to zero.</P><DIV class="g-section" id="gt-res-tools"><DIV class="gt-icon-c" closure_uid_soj8qo="3" id="gt-res-listen" style="display: none;" tabindex="0"></DIV><DIV id="gt-res-dict" style="display: none;"><H3><A href="http://www.google.com.ar/dictionary?source=translation&amp;hl=es&amp;q=&amp;langpair=en|es" id="gt-res-dict-link"></A></H3></DIV></DIV><BR /><BR /> <DIV class="g-section" id="gt-res-tools"></DIV><P style="MARGIN: 0cm 0cm 0pt">Example:</P><P style="MARGIN: 0cm 0cm 0pt"></P><P style="MARGIN: 0cm 0cm 0pt">Previous Year<STRONG>( 2009 <span class="lia-unicode-emoji" title=":disappointed_face:">šŸ˜ž</span></STRONG></P><P style="MARGIN: 0cm 0cm 0pt"><B>Month</B> 01 02 03 04 05 06 07 08 09 10 11 12</P><P style="MARGIN: 0cm 0cm 0pt">Sale0 0 0 50 100 100 120 120 101 50 60 80</P><P style="MARGIN: 0cm 0cm 0pt"></P><P style="MARGIN: 0cm 0cm 0pt"></P><P></P><P style="MARGIN: 0cm 0cm 0pt">Current Year<STRONG>( 2010 <span class="lia-unicode-emoji" title=":disappointed_face:">šŸ˜ž</span></STRONG></P><P style="MARGIN: 0cm 0cm 0pt"><B>Month</B> 01 02 03 04 05 06 07 08 09 10 11 12</P><P style="MARGIN: 0cm 0cm 0pt">Sale10 100 110 50 100 100 120 120 101 50 60 80</P><P style="MARGIN: 0cm 0cm 0pt"></P><P style="MARGIN: 0cm 0cm 0pt"></P><P></P><P style="MARGIN: 0cm 0cm 0pt">Show<STRONG>:</STRONG></P><P style="MARGIN: 0cm 0cm 0pt"><B>Month</B> 01 02 03 04 05 06 07 08 09 10 11 12</P><P style="MARGIN: 0cm 0cm 0pt">Sale0 0 0 50 100 100 120 120 101 50 60 80</P><P></P><P>I use this set analysis and shows me current stores that were open last year, but I have values in the months that no sales the previous year:</P><P>sum({$&lt;negocio= p({$&lt;aƱo={"$(=YEAR(addmonths(max(fecha),-12)))"}&gt;} negocio) &gt;} ventas)</P><P></P><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Fri, 08 Oct 2010 13:57:36 GMT 2010-10-08T13:57:36Z SetAnalisis https://community.qlik.com/t5/QlikView/SetAnalisis/m-p/232227#M83871 <HTML><HEAD></HEAD><BODY><P style="MARGIN: 0cm 0cm 0pt">I have to bring all businesses in the current year that were open last year and businesses that the month previous year did not sell to zero.</P><DIV class="g-section" id="gt-res-tools"><DIV class="gt-icon-c" closure_uid_soj8qo="3" id="gt-res-listen" style="display: none;" tabindex="0"></DIV><DIV id="gt-res-dict" style="display: none;"><H3><A href="http://www.google.com.ar/dictionary?source=translation&amp;hl=es&amp;q=&amp;langpair=en|es" id="gt-res-dict-link"></A></H3></DIV></DIV><BR /><BR /> <DIV class="g-section" id="gt-res-tools"></DIV><P style="MARGIN: 0cm 0cm 0pt">Example:</P><P style="MARGIN: 0cm 0cm 0pt"></P><P style="MARGIN: 0cm 0cm 0pt">Previous Year<STRONG>( 2009 <span class="lia-unicode-emoji" title=":disappointed_face:">šŸ˜ž</span></STRONG></P><P style="MARGIN: 0cm 0cm 0pt"><B>Month</B> 01 02 03 04 05 06 07 08 09 10 11 12</P><P style="MARGIN: 0cm 0cm 0pt">Sale0 0 0 50 100 100 120 120 101 50 60 80</P><P style="MARGIN: 0cm 0cm 0pt"></P><P style="MARGIN: 0cm 0cm 0pt"></P><P></P><P style="MARGIN: 0cm 0cm 0pt">Current Year<STRONG>( 2010 <span class="lia-unicode-emoji" title=":disappointed_face:">šŸ˜ž</span></STRONG></P><P style="MARGIN: 0cm 0cm 0pt"><B>Month</B> 01 02 03 04 05 06 07 08 09 10 11 12</P><P style="MARGIN: 0cm 0cm 0pt">Sale10 100 110 50 100 100 120 120 101 50 60 80</P><P style="MARGIN: 0cm 0cm 0pt"></P><P style="MARGIN: 0cm 0cm 0pt"></P><P></P><P style="MARGIN: 0cm 0cm 0pt">Show<STRONG>:</STRONG></P><P style="MARGIN: 0cm 0cm 0pt"><B>Month</B> 01 02 03 04 05 06 07 08 09 10 11 12</P><P style="MARGIN: 0cm 0cm 0pt">Sale0 0 0 50 100 100 120 120 101 50 60 80</P><P></P><P>I use this set analysis and shows me current stores that were open last year, but I have values in the months that no sales the previous year:</P><P>sum({$&lt;negocio= p({$&lt;aƱo={"$(=YEAR(addmonths(max(fecha),-12)))"}&gt;} negocio) &gt;} ventas)</P><P></P><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Fri, 08 Oct 2010 13:57:36 GMT https://community.qlik.com/t5/QlikView/SetAnalisis/m-p/232227#M83871 2010-10-08T13:57:36Z