set analysis using Addmonths

Anonymous — Tue, 06 Sep 2016 08:30:19 GMT

I need to write a set analysis expression using addmonths? Below is my expression that i want to convert using set analysis

if(

count(aggr(if(1- (sum(if(MonthName(AddMonths(Today(),-2),0)=PERIOD_NAME,CUSTOMER_IMPACT_MINS))/
sum(if(MonthName(AddMonths(Today(),-2),0)<=today(),MINS_IN_MON)))<=Only({<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]),[Service Id]),[Service Name]))= 0,'No Service missed SLA',

count(aggr(if(1- (sum(if(MonthName(AddMonths(Today(),-2),0)=PERIOD_NAME,CUSTOMER_IMPACT_MINS))/
sum(if(MonthName(AddMonths(Today(),-2),0)=PERIOD_NAME,MINS_IN_MON)))<=Only({<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]),[Service Id]),[Service Name])))

Re: set analysis using Addmonths

Gysbert_Wassenaar — Tue, 06 Sep 2016 11:53:21 GMT

If statements with else branches cannot be converted to set analysis statements. Sets are sets, not alternative execution paths.

topic set analysis using Addmonths in QlikView

set analysis using Addmonths

Re: set analysis using Addmonths