topic Re: Filter by mounth in QlikView https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466766#M174415 <HTML><HEAD></HEAD><BODY><P>Take a look at the following link:</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/48693">http://community.qlik.com/thread/48693</A></P></BODY></HTML> Thu, 21 Mar 2013 16:19:15 GMT 2013-03-21T16:19:15Z Filter by mounth https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466765#M174414 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to filter column [DATE MOV] by month January, February,etc as far as December.</P><P></P><P>Someone have an idea, how to proceed?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="471"><TBODY><TR><TD class="xl65" height="17" width="125">[LIEU POS]</TD><TD class="xl65" style="border-left: none;" width="80">[TRANS]</TD><TD class="xl65" style="border-left: none;" width="80">[DATE MOV]</TD><TD class="xl65" style="border-left: none;" width="100">[DATE ENTREE]</TD><TD class="xl65" style="border-left: none;" width="86">[TOT CON]</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT CON</TD><TD class="xl67" style="border-top: none; border-left: none;">GETMA</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">08/01/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">10/12/2012</TD><TD class="xl66" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT CON</TD><TD class="xl67" style="border-top: none; border-left: none;">J-B-Z</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">28/02/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">19/02/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT CON</TD><TD class="xl67" style="border-top: none; border-left: none;">J-B-Z</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">04/03/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">19/02/2013</TD><TD class="xl66" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT CON</TD><TD class="xl67" style="border-top: none; border-left: none;">SV-CON</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">16/03/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">04/03/2013</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT ET P</TD><TD class="xl67" style="border-top: none; border-left: none;">GETMA</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">05/03/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">28/11/2012</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT ET P</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT ET P</TD><TD class="xl67" style="border-top: none; border-left: none;">J-B-Z</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">28/02/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">19/02/2013</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT ET P</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT ET P</TD><TD class="xl67" style="border-top: none; border-left: none;">SV-CON</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">07/01/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">15/12/2012</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT ET P</TD><TD class="xl67" style="border-top: none; border-left: none;">SV-CON</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">08/01/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">15/12/2012</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT ET P CON</TD><TD class="xl67" style="border-top: none; border-left: none;">SV-CON</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">02/01/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">10/12/2012</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOT ET P CON</TD><TD class="xl67" style="border-top: none; border-left: none;">SV-CON</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">04/01/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">10/12/2012</TD><TD class="xl67" style="border-top: none; border-left: none;">TOT CON</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOUTY</TD><TD class="xl67" style="border-top: none; border-left: none;">SUPER </TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">25/02/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">16/02/2013</TD><TD class="xl67" style="border-top: none; border-left: none;">TOUTY</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOUTY</TD><TD class="xl67" style="border-top: none; border-left: none;">SUPER </TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">08/03/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">26/02/2013</TD><TD class="xl67" style="border-top: none; border-left: none;">TOUTY</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">TOUTY</TD><TD class="xl67" style="border-top: none; border-left: none;">SUPER </TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11/03/2013</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">25/02/2013</TD><TD class="xl67" style="border-top: none; border-left: none;">TOUTY</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 21 Mar 2013 16:14:33 GMT https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466765#M174414 realpixel 2013-03-21T16:14:33Z Re: Filter by mounth https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466766#M174415 <HTML><HEAD></HEAD><BODY><P>Take a look at the following link:</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/48693">http://community.qlik.com/thread/48693</A></P></BODY></HTML> Thu, 21 Mar 2013 16:19:15 GMT https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466766#M174415 2013-03-21T16:19:15Z Re: Filter by mounth https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466767#M174416 <HTML><HEAD></HEAD><BODY><P>You can use below script.... while loading the file.</P><P></P><P>LOAD</P><P>[LIEU POS],</P><P>[TRANS],</P><P>[DATE MOV],</P><P>[DATE ENTREE],</P><P>[TOT CON],</P><P>month([DATE MOV]) as Month_Name</P><P>from......</P></BODY></HTML> Fri, 22 Mar 2013 15:47:21 GMT https://community.qlik.com/t5/QlikView/Filter-by-mounth/m-p/466767#M174416 2013-03-22T15:47:21Z