Set Analysis <= Date

james — Wed, 08 Jul 2009 02:26:11 GMT

All, I have been using IF statements, which seem to drag the speed

=sum(If([FCST.Date] <= vMaxDate,if(PlanVersion='0',Rev)))

I cannot seem to get the above to work in set analysis

Help?!?!

I have been trying

sum({$<Date = {FCST.Date <= {vMaxDate},[PlanVersion]= {'0'}>} Rev

Wed, 08 Jul 2009 02:37:55 GMT

Here is an example I used which may help you a little bit... Be careful though, set analysis can get pretty slow as well.


Sum({$<[_kDate] = {"<=$(=addmonths($(vMaxActualDate),-12))"}>} [Actual Cost])

topic Set Analysis <= Date in QlikView