topic Help with a expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-a-expression/m-p/432697#M1157491 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have this expression<SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13607584546632043" jivemacro_uid="_13607584546632043"><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"><P>sum</P></SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Time_Per_Day</SPAN><SPAN style="font-size: 8pt;">)*</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">OrderTxt</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">OrderID,CustomID</SPAN><SPAN style="font-size: 8pt;">) / 60) </SPAN></SPAN><P></P></PRE><P></P><P>How do I add so it only do the calculation for max(OrderID) for each CustomerID and DeparmentNr?</P><P>Today it sometimes gets wrong beacuse if a order are changed the first are not removed, instead a new are created and I only want to sum the time for the latest order </P><P></P><P>Please let me now if I should give a better context.&nbsp;&nbsp; </P><P></P><P>Edit: maybe hard to read in above textbox</P><P>sum(aggr(sum(Time_Per_Day)*count(distinct Date), Date,OrderTxt, OrderID,CustomID) / 60)</P></BODY></HTML> Wed, 13 Feb 2013 12:18:53 GMT 2013-02-13T12:18:53Z Help with a expression https://community.qlik.com/t5/QlikView/Help-with-a-expression/m-p/432697#M1157491 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have this expression<SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13607584546632043" jivemacro_uid="_13607584546632043"><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"><P>sum</P></SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Time_Per_Day</SPAN><SPAN style="font-size: 8pt;">)*</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">OrderTxt</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">OrderID,CustomID</SPAN><SPAN style="font-size: 8pt;">) / 60) </SPAN></SPAN><P></P></PRE><P></P><P>How do I add so it only do the calculation for max(OrderID) for each CustomerID and DeparmentNr?</P><P>Today it sometimes gets wrong beacuse if a order are changed the first are not removed, instead a new are created and I only want to sum the time for the latest order </P><P></P><P>Please let me now if I should give a better context.&nbsp;&nbsp; </P><P></P><P>Edit: maybe hard to read in above textbox</P><P>sum(aggr(sum(Time_Per_Day)*count(distinct Date), Date,OrderTxt, OrderID,CustomID) / 60)</P></BODY></HTML> Wed, 13 Feb 2013 12:18:53 GMT https://community.qlik.com/t5/QlikView/Help-with-a-expression/m-p/432697#M1157491 2013-02-13T12:18:53Z