Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set analysis using Addmonths

hi

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

1 Reply
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand