Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajithsachin
Partner - Contributor II
Partner - Contributor II

Average Date Difference

hi..

i have a table like this

codedate
0101/04/12
0108/04/12
0119/04/12
0201/04/12
0302/04/12
0410/04/12

i need the average date difference of each code

can anybody please help..

1 Solution

Accepted Solutions
Not applicable

Mark the discussion to closure.

Kiran.

View solution in original post

3 Replies
Not applicable

avg(aggr(max(date)-min(date),code))

should do.

Kiran Rokkam.

ajithsachin
Partner - Contributor II
Partner - Contributor II
Author

Thanks a lot..

Not applicable

Mark the discussion to closure.

Kiran.