Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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
Partner - Champion III
Partner - Champion III

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