topic Re: Filter between two dates in QlikView

Filter between two dates

amigosos — Thu, 17 Nov 2011 17:27:57 GMT

What's wrong?

NTrabajo	FechaFinReal2	sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
		473586,824
DD-2001-A	21/11/1997	1,25
DP-0219-A	12/06/1998	8
DP-0416-A	31/12/1998	10
DP-0417-A	01/10/1998	1
DR-0096-A	15/06/1998	2
DR-0300-A	06/11/1998	4,5
ED-0011-A	18/01/1999	4,5
ED-0047-A	30/03/1999	2
ED-0146-A	17/12/1999	2,5
EP-0056-A	29/03/1999	0,75
EP-0280-A	24/01/2011	0,45
EP-0301-A	22/02/2000	10

Thanks

Re: Filter between two dates

johnw — Thu, 17 Nov 2011 21:55:28 GMT

What numbers do you WANT to see? Why?

What you MAY have expected was for the set analysis to override your dimension value. It doesn't. It INTERSECTS your dimension value. If the dimension is in range, it'll use the dimension. If not, you'll get null. If you instead need to override your dimension value, you'd use the 'total' key word:

sum({<FechaFinReal2={">=01/01/2011 <=31/12/2011" }>} total Horas)

I have no idea if that's what you want, though.

Filter between two dates

amigosos — Fri, 18 Nov 2011 07:40:16 GMT

Thanks John,

I try to explain me. I want present a table with all "NTrabajos" (jobs), which "FechaFinReal2" (finaldate) is in 2011, and present the "Horas" (dedications; hours) worked and each job.

For example:

NTrabajo	FechaFinReal2	sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
		0,45
EP-0280-A	24/01/2011	0,45

Re: Filter between two dates

amigosos — Fri, 18 Nov 2011 07:40:52 GMT

Thanks John,

I try to explain me. I want present a table with all "NTrabajos" (jobs), which "FechaFinReal2" (finaldate) is in 2011, and present the "Horas" (dedications; hours) worked and each job.

For example:

NTrabajo	FechaFinReal2	sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
		0,45
EP-0280-A	24/01/2011	0,45

Re: Filter between two dates

amigosos — Fri, 18 Nov 2011 09:28:49 GMT

I've found the error:

sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)

Î this space is the error.

The correct form is:

sum({<FechaFinReal2={">=01/01/2011 <=31/12/2011" }>} Horas)