topic Re: Compare equivalent days in QlikView https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281963#M498005 <HTML><HEAD></HEAD><BODY><P>Yo hace mucho tiempo solicité el acceso al grupo Chile pero nadie ha contestado... puedes hacer algo???</P></BODY></HTML> Wed, 06 Aug 2014 14:02:00 GMT 2014-08-06T14:02:00Z Compare equivalent days https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281959#M498001 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P><SPAN class="hps">I'm pretty new to Qlikview, and Recently</SPAN> <SPAN class="hps">I am developing a</SPAN> <SPAN class="hps">Model for my company. I have to compare the sales (and other fields) of this year with the past year. This looks easy, But sometimes i cant compare today with the same day of the last year, because i cant compare a Monday with a Saturday, or with a Holiday. I try to fix this using a table with two columns, "Day" and "Equivalent Day", but i really dont know how to manage this in the code.</SPAN></P><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps">Greetings from Chile, and thank you for help!.</SPAN></P><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps"> </SPAN></P></BODY></HTML> Thu, 22 Sep 2011 12:30:54 GMT https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281959#M498001 radokotbk 2011-09-22T12:30:54Z Compare equivalent days https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281960#M498002 <HTML><HEAD></HEAD><BODY><P>Did you ever find a solution for this?</P></BODY></HTML> Thu, 10 May 2012 17:32:58 GMT https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281960#M498002 2012-05-10T17:32:58Z Compare equivalent days https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281961#M498003 <HTML><HEAD></HEAD><BODY><P>puedes redactar el problema en español, te recomiendo buscar el grupo Qlikview Chile</P></BODY></HTML> Thu, 10 May 2012 17:41:39 GMT https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281961#M498003 2012-05-10T17:41:39Z Re: Compare equivalent days https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281962#M498004 <HTML><HEAD></HEAD><BODY><P>Hola</P><P></P><P>Te recomiendo que uses un campo de semanas, y te muevas por estas semanas ( semana 1 del 2014 v/s semana 1 del 2013) y tus gráficos comparativos muestres de lunes a domingo</P><P></P><TABLE class="infotable persist-area"><THEAD><TR class="persist-header"><TH class="tdvalue header">Semanas 2014</TH><TH class="tdvalue header">Comienza</TH><TH class="tdvalue header">Finaliza</TH></TR></THEAD><TBODY><TR><TD>Semana 01</TD><TD>30 diciembre 2013</TD><TD>5 enero 2014</TD></TR><TR><TD>Semana 02</TD><TD>6 enero 2014</TD><TD>12 enero 2014</TD></TR><TR><TD>Semana 03</TD><TD>13 enero 2014</TD><TD>19 enero 2014</TD></TR><TR><TD>Semana 04</TD><TD>20 enero 2014</TD><TD>26 enero 2014</TD></TR><TR><TD>Semana 05</TD><TD>27 enero 2014</TD><TD>2 febrero 2014</TD></TR><TR><TD>Semana 06</TD><TD>3 febrero 2014</TD><TD>9 febrero 2014</TD></TR><TR><TD>Semana 07</TD><TD>10 febrero 2014</TD><TD>16 febrero 2014</TD></TR></TBODY></TABLE><P></P><P>O sea a tu tabla date deberás agregar un campo mas que es la semana que está esa fecha.</P><P>TablaDate</P><P>Fecha</P><P>Mes</P><P>día</P><P>NumeroSemana</P><P></P><P>Te adjunto un link que habla del nuemero de semana.</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers">http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers</A></P><P></P><P>Saludos de Pto. Varas,</P></BODY></HTML> Wed, 06 Aug 2014 14:00:23 GMT https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281962#M498004 2014-08-06T14:00:23Z Re: Compare equivalent days https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281963#M498005 <HTML><HEAD></HEAD><BODY><P>Yo hace mucho tiempo solicité el acceso al grupo Chile pero nadie ha contestado... puedes hacer algo???</P></BODY></HTML> Wed, 06 Aug 2014 14:02:00 GMT https://community.qlik.com/t5/QlikView/Compare-equivalent-days/m-p/281963#M498005 2014-08-06T14:02:00Z