Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
FinService
Contributor
Contributor

Simple day average from 2 fact rows aggregated by order

Hello guys, I have a simple question about calculating average date diff (in days) between two facts of the same order.

Here is a sample data:

Qlik_DateDiff1.png

The result should be 4,4. 
I think I should use Aggr by Order Id but I don't know how to calculate the delta using the 2 Fact Types (SENT and DELIVERED).

Qlik_DateDiff2.png

 

Can you help with that measure? Thank you

1 Reply
Brett_Bleess
Support (Former)
Support (Former)

Best I have is the following, hopefully may put you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.