topic Re: Organic Vs Inorganic Growth in QlikView https://community.qlik.com/t5/QlikView/Organic-Vs-Inorganic-Growth/m-p/647494#M237133 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>Please could someone advise what the below expression is doing and does it make sense...</P><P></P><P>=num(sum(aggr(if(sum({1&lt;Fin_Year={$(vMaxFinancialYear)}&gt;} $(vSales)) &lt;&gt; 0</P><P>and </P><P>sum({1&lt;Fin_Year={$(vPrevFinYear)}, Fin_Period = {"&lt;= $(vMax<SPAN style="font-size: 13.3333339691162px;">Financial</SPAN>Period)"}&gt;} $(vSales)) &gt; 0,sum({1&lt;Fin_Year={$(vMax<SPAN style="font-size: 13.3333339691162px;">Financial</SPAN>Year)}&gt;} $(vSales))),Customer)),'R # ##0;R-# ##0')</P></BODY></HTML> Thu, 02 Oct 2014 07:33:18 GMT rido1421 2014-10-02T07:33:18Z Organic Vs Inorganic Growth https://community.qlik.com/t5/QlikView/Organic-Vs-Inorganic-Growth/m-p/647493#M237132 <HTML><HEAD></HEAD><BODY><P>Hi All </P><P></P><P>I would like to create a Model displaying the Organic and Inorganic Sales value growth based on customers for previous year and current year</P><P>is there perhaps any sample qvws that I could use as a guide?</P></BODY></HTML> Thu, 02 Oct 2014 05:50:40 GMT https://community.qlik.com/t5/QlikView/Organic-Vs-Inorganic-Growth/m-p/647493#M237132 rido1421 2014-10-02T05:50:40Z Re: Organic Vs Inorganic Growth https://community.qlik.com/t5/QlikView/Organic-Vs-Inorganic-Growth/m-p/647494#M237133 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>Please could someone advise what the below expression is doing and does it make sense...</P><P></P><P>=num(sum(aggr(if(sum({1&lt;Fin_Year={$(vMaxFinancialYear)}&gt;} $(vSales)) &lt;&gt; 0</P><P>and </P><P>sum({1&lt;Fin_Year={$(vPrevFinYear)}, Fin_Period = {"&lt;= $(vMax<SPAN style="font-size: 13.3333339691162px;">Financial</SPAN>Period)"}&gt;} $(vSales)) &gt; 0,sum({1&lt;Fin_Year={$(vMax<SPAN style="font-size: 13.3333339691162px;">Financial</SPAN>Year)}&gt;} $(vSales))),Customer)),'R # ##0;R-# ##0')</P></BODY></HTML> Thu, 02 Oct 2014 07:33:18 GMT https://community.qlik.com/t5/QlikView/Organic-Vs-Inorganic-Growth/m-p/647494#M237133 rido1421 2014-10-02T07:33:18Z