Set Analysis Date Range is not Working

Thu, 27 Nov 2014 12:02:31 GMT

Hi All,

My Expression is : Sum({<Date = {">=$(=v_CompDt)<=$(=vWeekToDate)"}>} TOTAL_UNITS_SOLD)

where ::

1) v_CompDt is the date when the Actual Sales happen [Date(Max(num(Date)),'DD/MM/YYYY')].

2) vWeekToDate is a calendar variable which user can select from drop down.

So my o/p for TOTAL_UNITS_SOLD should come in the range of (v_CompDt to vWeekToDate) .

To Display I am using Pivot Chart with Dimensions, Country,Location.

Country	Location	COMP_DATE	Expression
INDONESIA	LOCATION1	10/08/2014	12100(this should come from 10/08/14-1 0/11/14(vWeekToDt) but currently its taking 19/10/15 (as v_CompDt = max(Date), its taking max among all n leading to wrong info)-10/11/14.
INDONESIA	LOCATION2	12/08/2014	18000
INDONESIA	LOCATION3	19/10/2015	26200

Anyone knows how to resolve this problem?? Even I tried using AGGR but it's not working out for me. it (v_CompDt) always takes max(Date).

Thanks.

Regards,

Yojas

topic Set Analysis Date Range is not Working in QlikView