Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor III

Set Analysis <= Date

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


I have been trying

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

Tags (1)
1 Reply
Not applicable

Set Analysis <= Date

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])

Community Browser