topic agg in the script in QlikView https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206216#M1207473 <HTML><HEAD></HEAD><BODY><P>what error is happening?</P></BODY></HTML> Fri, 11 Dec 2009 02:33:20 GMT Qlik_Trigg 2009-12-11T02:33:20Z agg in the script https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206215#M1207472 <HTML><HEAD></HEAD><BODY><P></P><P></P><P></P><P style="font-style: italic"></P><P style="font-style: italic">What am I doing wrong?</P><P style="font-style: italic"></P><P style="font-style: italic">[Min PPU]:</P><B></B><P style="font-weight: bold">Load</P><B></B><P style="font-weight: bold"></P><P></P>Family, <P>Scenario</P><P></P><P>,</P><P>[Product Name]</P><P></P><P>,</P><P>[Total Purchase Cost]</P><P></P><P>,</P><P>[Minimum Desired Quantity],</P><P>If</P><P></P><P>(([Product Name]=Previous([Product Name]) <B>and</B> Scenario = Previous(Scenario)),</P><P>min</P><BR /><BR /> <P>([Total Purchase Cost]/[Minimum Desired Quantity]) <B>as</B> [MinPPU per P]))</P><B></B><P style="font-weight: bold">resident</P><B></B> <P>Main</P><B></B><P style="font-weight: bold">order</P><P><B>by</B></P><P>Family</P><P></P><BR /><BR /> <P>,Product,Scenario;</P><I></I><P style="font-style: italic">Main:</P><B></B><P style="font-weight: bold">LOAD</P><P>Supplier,</P><P></P><P></P><P>Category,</P><P></P><P></P><P>[Item Name],</P><P></P><P></P><P>[Minimum Desired Quantity],</P><P></P><P></P><P>Segment,</P><P></P><P></P><P>Family,</P><P></P><P></P><P>[Article number],</P><P></P><P></P><P>[Component number],</P><P></P><P></P><P>Scenario,</P><P></P><P></P><P>[Product Name],</P><P></P><P></P><P>[Article/Component],</P><P></P><P></P><P>[Price Per Unit],</P><P></P><P></P><P>[Historical Cost],</P><P></P><P></P><P>[Total Historical Cost],</P><P></P><P></P><P>[Total Purchase Cost],</P><P></P><P></P><P>[Projected Savings],</P><P></P><P></P><P>from</P><P>blablabla;</P><BR /><BR /> <P style="font-weight: bold"></P><P></P><P></P></BODY></HTML> Wed, 09 Dec 2009 19:07:27 GMT https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206215#M1207472 2009-12-09T19:07:27Z agg in the script https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206216#M1207473 <HTML><HEAD></HEAD><BODY><P>what error is happening?</P></BODY></HTML> Fri, 11 Dec 2009 02:33:20 GMT https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206216#M1207473 Qlik_Trigg 2009-12-11T02:33:20Z agg in the script https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206217#M1207474 <HTML><HEAD></HEAD><BODY><P style="font-weight: bold"></P><P style="font-weight: bold">maybe the last comma just before the fronm</P><P style="font-weight: bold"></P><P style="font-weight: bold">[Projected Savings],</P><P></P><P></P><P>from</P><P>blablabla;</P><BR /><BR /></BODY></HTML> Fri, 11 Dec 2009 04:28:23 GMT https://community.qlik.com/t5/QlikView/agg-in-the-script/m-p/206217#M1207474 2009-12-11T04:28:23Z