topic Re: AGGR () by row in App Development https://community.qlik.com/t5/App-Development/AGGR-by-row/m-p/112821#M7786 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>take a look at function above()</P><P>could be something like : Date - above(Date)</P><P></P><P>with ID, Date as dimension</P><P>and if so count(ID) works, aggr not usefull</P><P></P><P>regards</P></BODY></HTML> Tue, 11 Sep 2018 08:31:32 GMT ogautier62 2018-09-11T08:31:32Z AGGR () by row https://community.qlik.com/t5/App-Development/AGGR-by-row/m-p/112820#M7785 <HTML><HEAD></HEAD><BODY><P>I need to calculate the difference between multiple dates by row, by ID. I used the AGGR() function to count the number dates within each ID's.&nbsp; But now I need to calculate the difference, in days, between each date within each ID. Any help would be greatly appreciated! Cheers!</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213169_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 10 Sep 2018 17:40:48 GMT https://community.qlik.com/t5/App-Development/AGGR-by-row/m-p/112820#M7785 pete_bolin 2018-09-10T17:40:48Z Re: AGGR () by row https://community.qlik.com/t5/App-Development/AGGR-by-row/m-p/112821#M7786 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>take a look at function above()</P><P>could be something like : Date - above(Date)</P><P></P><P>with ID, Date as dimension</P><P>and if so count(ID) works, aggr not usefull</P><P></P><P>regards</P></BODY></HTML> Tue, 11 Sep 2018 08:31:32 GMT https://community.qlik.com/t5/App-Development/AGGR-by-row/m-p/112821#M7786 ogautier62 2018-09-11T08:31:32Z