Filter by mounth

[realpixel]

Hello,

I want to filter column [DATE MOV] by month January, February,etc as far as December.

Someone have an idea, how to proceed?

[LIEU POS]	[TRANS]	[DATE MOV]	[DATE ENTREE]	[TOT CON]
TOT CON	GETMA	08/01/2013	10/12/2012	TOT CON
TOT CON	J-B-Z	28/02/2013	19/02/2013	TOT CON
TOT CON	J-B-Z	04/03/2013	19/02/2013	TOT CON
TOT CON	SV-CON	16/03/2013	04/03/2013	TOT CON
TOT ET P	GETMA	05/03/2013	28/11/2012	TOT ET P
TOT ET P	J-B-Z	28/02/2013	19/02/2013	TOT ET P
TOT ET P	SV-CON	07/01/2013	15/12/2012	TOT CON
TOT ET P	SV-CON	08/01/2013	15/12/2012	TOT CON
TOT ET P CON	SV-CON	02/01/2013	10/12/2012	TOT CON
TOT ET P CON	SV-CON	04/01/2013	10/12/2012	TOT CON
TOUTY	SUPER	25/02/2013	16/02/2013	TOUTY
TOUTY	SUPER	08/03/2013	26/02/2013	TOUTY
TOUTY	SUPER	11/03/2013	25/02/2013	TOUTY

[#2]

Take a look at the following link:

http://community.qlik.com/thread/48693

[#3 · Accepted solution]

You can use below script.... while loading the file.

LOAD

[LIEU POS],

[TRANS],

[DATE MOV],

[DATE ENTREE],

[TOT CON],

month([DATE MOV]) as Month_Name

from......