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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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