topic Re: Determin latest Throuputrate in QlikView https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385043#M421764 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(If(StartDate = Max(TOTAL &lt;Products&gt; StartDate), Sum(mmaxStart)), Product, StartDate))</STRONG></P></BODY></HTML> Fri, 25 Aug 2017 13:16:40 GMT sunny_talwar 2017-08-25T13:16:40Z Determin latest Throuputrate https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385042#M421763 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have different throughput rates for one product. These throughput rates have different start and end times. Now I want to know the latest thruputrate which was entered in the System.</P><P></P><P>I try to get this with the following Statements:</P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">StartDate</SPAN><SPAN style="font-size: 8pt;">={'$(=max(StartDate))'}&gt;}(</SPAN><SPAN style="color: #800000; font-size: 8pt;">mmaxStart</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Unfortunately this only delivers data for the some of the Products. Only those which have the same Change date. </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">For example 5 Products got a new throughput rate at the 01.01.2017. 10 Products were Change at the 01.12.2016. The result is that only for the 5 products my throughput rate is displayed. The other ones get displayed as 0. </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">When I query the </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">=max(StartDate) for each Product it displayes me the correct Date. </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Any ideas what I am overlooking? </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thanks for your help. </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Stefan</SPAN></P></BODY></HTML> Fri, 25 Aug 2017 13:11:33 GMT https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385042#M421763 2017-08-25T13:11:33Z Re: Determin latest Throuputrate https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385043#M421764 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(If(StartDate = Max(TOTAL &lt;Products&gt; StartDate), Sum(mmaxStart)), Product, StartDate))</STRONG></P></BODY></HTML> Fri, 25 Aug 2017 13:16:40 GMT https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385043#M421764 sunny_talwar 2017-08-25T13:16:40Z Re: Determin latest Throuputrate https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385044#M421765 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>es this works. Great. I was sitting over this for the whole morning.</P><P></P><P>Thank you very much.</P><P>Stefan</P></BODY></HTML> Fri, 25 Aug 2017 13:24:24 GMT https://community.qlik.com/t5/QlikView/Determin-latest-Throuputrate/m-p/1385044#M421765 2017-08-25T13:24:24Z