Date range in Set Analysis

[#1]

Hi All,

I have here a table:

I need to create an analysis, what is the total Qty of the Report Date with the specific date range.

ex: For Report date 20-Sep-14, the range is >=14-SEp-14<=20-Sep-14

How can I include this in my set analysis?

Thanks!

[anbu1984]

=Sum(If(Num(Report_Date) >= (Report_Date-6) And Report_Date<=Report_Date,Qty))

[#3]

here's a sample document you guys can check out

[#4]

jagan mohan

[#5]

I have attached a sample qvw below

[#6]

bump

[jagan]

Hi,

Qlikview calculations are done at table level not by row level, so it is not possible in front end, if you just want for one day then use below expression

=Sum({<Report_Date={'>=$(=date(Max([Rpt Date])-6))<=$(=Date(Max([Rpt Date])))'}>}Qty)

if you want for all the days then you have pre calculate in script by using Peek or Previous().

Hope this helps you.

Regards,

Jagan.