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: 
suvechha_b
Creator III
Creator III

Need Help

Can some one help to write the expression :

if(name= 'RISK',RangeMin(0,aggr(rangesum(above(sum([sales_plan]), 0, rowno())), [Fiscal Month]) - aggr(rangesum(above(sum(projected_adjustment_unit),0, rowno())),[Fiscal Month])),

My risk should be calculated against [Fiscal Month] and [year].

when I am writing it with aggr function like this , its having result but taking all [Fiscal Month] and [year]

if(name= 'RISK',rangesum(above(sum([sales_plan]), 0, rowno())) - rangesum(above(sum(projected_adjustment_unit),0, rowno())),

2 Replies
Not applicable

share data sample

suvechha_b
Creator III
Creator III
Author

See the RISK calculation in expression.