sum with date range

[Anonymous]

I have a table as follows:

SoldDate               Qty               item id

01/04/2010               12               1

02/04/2010               13               2

03/06/2010               15               1

01/07/2010        8               3

07/12/2010               9        2

01/01/2011               10               1

02/02/2011               11               1

01/03/2011               10               2

Points to be noted:

1.Data are kept as per financial year (apr-mar) i.e 2010-2011

My selection:

Financial year          =2010-2011

Month                    =Feb 2011

Based on the selection the report will be

Item Id          Expression 1                                            Expression 2

1                 sum(qty for the period apr 2010-jan 2011)               sum(qty for the month feb 2011)

2                                   sum(qty for the period apr 2010-jan 2011)               sum(qty for the month feb 2011)

3                                   sum(qty for the period apr 2010-jan 2011)               sum(qty for the month feb 2011)

Thanks and regards

chandan

[chriscammers]

check out this thread http://community.qlik.com/message/56620#56620

the trick to this is to use set analysis to define the date range you'd like to see in the chart..