topic Help with set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/347699#M128694 <HTML><HEAD></HEAD><BODY><P>I got a Document with 2 tables (Inventory, and Retail)</P><P>The inventory table is related to Retail via a column called RetailKey</P><P>What i want to calculate is the original retail which is to get the first unit retail of each item and multiply it by sum of quantities </P><P>Actually the user has to select an up to date for quantities calculation and another retail date</P><P></P><P>my expression is as follows:</P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">sum(aggr(FirstSortedValue({&lt;H_BPDate={"&lt;=$(vRetailDate)"}&gt;}[Unit Retail], -H_BPDate) </SPAN></P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">* </SPAN></P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">sum(Total &lt;RetailKey&gt;{&lt;[Transaction Date]={"&lt;=$(vUpToDate)"}&gt;}Quantity) </SPAN></P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">,RetailKey))</SPAN></P><P></P><P>this expression is put in a pivot table with the following dimensions (Country, Business Unit, Season)</P><P></P><P>the results are correct but the performance is extremely slow</P><P></P><P>how can I enhance the above expression</P><P></P><P>Please advise</P></BODY></HTML> Mon, 11 Jun 2012 19:21:20 GMT ali_hijazi 2012-06-11T19:21:20Z Help with set analysis https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/347699#M128694 <HTML><HEAD></HEAD><BODY><P>I got a Document with 2 tables (Inventory, and Retail)</P><P>The inventory table is related to Retail via a column called RetailKey</P><P>What i want to calculate is the original retail which is to get the first unit retail of each item and multiply it by sum of quantities </P><P>Actually the user has to select an up to date for quantities calculation and another retail date</P><P></P><P>my expression is as follows:</P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">sum(aggr(FirstSortedValue({&lt;H_BPDate={"&lt;=$(vRetailDate)"}&gt;}[Unit Retail], -H_BPDate) </SPAN></P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">* </SPAN></P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">sum(Total &lt;RetailKey&gt;{&lt;[Transaction Date]={"&lt;=$(vUpToDate)"}&gt;}Quantity) </SPAN></P><P><SPAN style="font-family: arial, verdana, sans-serif; font-size: 12px; background-color: #ffffff;">,RetailKey))</SPAN></P><P></P><P>this expression is put in a pivot table with the following dimensions (Country, Business Unit, Season)</P><P></P><P>the results are correct but the performance is extremely slow</P><P></P><P>how can I enhance the above expression</P><P></P><P>Please advise</P></BODY></HTML> Mon, 11 Jun 2012 19:21:20 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/347699#M128694 ali_hijazi 2012-06-11T19:21:20Z