https://community.qlik.com/t5/QlikView/aggregate-in-set-expression/m-p/1839056#M1215148 <P>Hi all,</P><P><BR />I have a problem with a expression.</P><P>My formula is:</P><P>=aggr( Count({&lt; OrderDate= {"$(=date(FirstSortedValue(distinct OrderDate, aggr(OrderDate, OrderNumber))))"}&gt;} OrderNumber), OrderNumber)</P><P>What I try to achieve is that QV takes the first OrderDate value for each OrderNumber and counts the number of rows that have that OrderNumber in combination with the first OrderDate.</P><P>QV at the moment validates the OrderDate with the firstsortedvalue of alle the orderdates in the selection.&nbsp;<BR />Where am I going wrong in my expression?</P><P>&nbsp;</P><P>Much thanks in advance!</P> Fri, 24 Sep 2021 14:33:44 GMT Strooprover 2021-09-24T14:33:44Z https://community.qlik.com/t5/QlikView/aggregate-in-set-expression/m-p/1839056#M1215148 <P>Hi all,</P><P><BR />I have a problem with a expression.</P><P>My formula is:</P><P>=aggr( Count({&lt; OrderDate= {"$(=date(FirstSortedValue(distinct OrderDate, aggr(OrderDate, OrderNumber))))"}&gt;} OrderNumber), OrderNumber)</P><P>What I try to achieve is that QV takes the first OrderDate value for each OrderNumber and counts the number of rows that have that OrderNumber in combination with the first OrderDate.</P><P>QV at the moment validates the OrderDate with the firstsortedvalue of alle the orderdates in the selection.&nbsp;<BR />Where am I going wrong in my expression?</P><P>&nbsp;</P><P>Much thanks in advance!</P> Fri, 24 Sep 2021 14:33:44 GMT https://community.qlik.com/t5/QlikView/aggregate-in-set-expression/m-p/1839056#M1215148 Strooprover 2021-09-24T14:33:44Z