https://community.qlik.com/t5/App-Development/Is-it-possible-to-test-derived-fields-in-set-expressions/m-p/1791540#M61906 <P>Can I put a dimension derived with Aggr in the left side of a set expression?&nbsp; It's not working for me right now, but I'm not sure why.</P><P>For each product, I have the current stock and list of orders (with dates).&nbsp; I'm trying to get the date for each product when its stock will run out.</P><P>&nbsp;</P><LI-CODE lang="csharp">// This works fine. Set vd_stockRemaining = Aggr( Sum(TOTAL &lt;SKU&gt; m_stock) - Rangesum(Above(Sum(m_orders), 0, RowNo())), SKU, ([Order Date], NUMERIC)); // This does not work. It returns null for every SKU. Set vd_starvationDate = Aggr(Date( FirstSortedValue({&lt;$(vd_stockRemaining)={"&lt;=0"}&gt;}[Order Date], -$(vd_stockRemaining)) ), SKU);</LI-CODE><P>&nbsp;</P><P>I'm using this instead for now:</P><LI-CODE lang="csharp">// This works but seems hacky/overcomplicated. Set vd_starvationDate = Aggr(If(Sum(m_stock) &gt; Sum(m_orders), Null(), Date( FirstSortedValue([Order Date], If( $(vd_stockRemaining) &lt;= 0, -$(vd_stockRemaining), 1000000000000 ) ))), SKU);</LI-CODE><P>&nbsp;</P> Sat, 16 Nov 2024 00:25:59 GMT mmarchese 2024-11-16T00:25:59Z https://community.qlik.com/t5/App-Development/Is-it-possible-to-test-derived-fields-in-set-expressions/m-p/1791540#M61906 <P>Can I put a dimension derived with Aggr in the left side of a set expression?&nbsp; It's not working for me right now, but I'm not sure why.</P><P>For each product, I have the current stock and list of orders (with dates).&nbsp; I'm trying to get the date for each product when its stock will run out.</P><P>&nbsp;</P><LI-CODE lang="csharp">// This works fine. Set vd_stockRemaining = Aggr( Sum(TOTAL &lt;SKU&gt; m_stock) - Rangesum(Above(Sum(m_orders), 0, RowNo())), SKU, ([Order Date], NUMERIC)); // This does not work. It returns null for every SKU. Set vd_starvationDate = Aggr(Date( FirstSortedValue({&lt;$(vd_stockRemaining)={"&lt;=0"}&gt;}[Order Date], -$(vd_stockRemaining)) ), SKU);</LI-CODE><P>&nbsp;</P><P>I'm using this instead for now:</P><LI-CODE lang="csharp">// This works but seems hacky/overcomplicated. Set vd_starvationDate = Aggr(If(Sum(m_stock) &gt; Sum(m_orders), Null(), Date( FirstSortedValue([Order Date], If( $(vd_stockRemaining) &lt;= 0, -$(vd_stockRemaining), 1000000000000 ) ))), SKU);</LI-CODE><P>&nbsp;</P> Sat, 16 Nov 2024 00:25:59 GMT https://community.qlik.com/t5/App-Development/Is-it-possible-to-test-derived-fields-in-set-expressions/m-p/1791540#M61906 mmarchese 2024-11-16T00:25:59Z