Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Date Range is not Working

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.

CountryLocationCOMP_DATEExpression
INDONESIALOCATION110/08/201412100(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.
INDONESIALOCATION212/08/201418000
INDONESIALOCATION319/10/201526200

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

0 Replies