topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/536274#M1134793 <HTML><HEAD></HEAD><BODY><P>share data sample <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 18 Nov 2013 13:18:26 GMT 2013-11-18T13:18:26Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/536273#M1134792 <HTML><HEAD></HEAD><BODY><P>Can some one help to write the expression :</P><P></P><P></P><P>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])),</P><P></P><P></P><P>My risk should be calculated against [Fiscal Month] and [year].</P><P></P><P>when I am writing it with aggr function like this , its having result but taking all [Fiscal Month] and [year]</P><P></P><P>if(name= 'RISK',rangesum(above(sum([sales_plan]), 0, rowno())) - rangesum(above(sum(projected_adjustment_unit),0, rowno())),</P></BODY></HTML> Mon, 18 Nov 2013 08:04:43 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/536273#M1134792 suvechha_b 2013-11-18T08:04:43Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/536274#M1134793 <HTML><HEAD></HEAD><BODY><P>share data sample <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 18 Nov 2013 13:18:26 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/536274#M1134793 2013-11-18T13:18:26Z Re: Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/536275#M1134794 <HTML><HEAD></HEAD><BODY><P>See the RISK calculation in expression.</P></BODY></HTML> Mon, 18 Nov 2013 13:36:07 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/536275#M1134794 suvechha_b 2013-11-18T13:36:07Z