Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pete_bolin
Contributor
Contributor

AGGR () by row

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.  But now I need to calculate the difference, in days, between each date within each ID. Any help would be greatly appreciated! Cheers!

Capture.JPG

1 Reply
ogautier62
Specialist II
Specialist II

Hi,

take a look at function above()

could be something like : Date - above(Date)

with ID, Date as dimension

and if so count(ID) works, aggr not usefull

regards