topic Adding with a date range in QlikView

Adding with a date range

Fri, 24 May 2013 19:37:16 GMT

Hi,

given the data below, I'd like to sum up the Cost for each FGC only if date is in a certain range. Any help would be appreciated. Thank.

FGC	Cost	Date
A1	10	09/2012
A1	12	10/2012
A1	8	11/2012
A1	9	02/2013
A1	1	05/2013
B1	13	05/2012
B1	5	08/2012
B1	35	10/2012
B1	34	04/2013
C1	77	01/2012
C1	4	01/2013
C1	23	02/2012

I'd like to have: sum of cost per each FGC for a given date range (let's say date < 02/2013)

Re: Adding with a date range

Fri, 24 May 2013 20:02:03 GMT

It really depends on what you are trying to achieve. If you want the user to define the range, check into variables or a master calendar. Another option is set analysis. See attached for an example.

Re: Adding with a date range

Fri, 24 May 2013 20:03:55 GMT

Hi!

take a look!

Re: Adding with a date range

Fri, 24 May 2013 20:23:21 GMT

I'm trying to get the sum of FGC so for A1 I'm looking for 30 because 10+12+8=30 (filtering on date < 02/2013).