Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
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

Creator III
Creator III

See the RISK calculation in expression.