Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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.