Average difference between two dates in same column

alliedarmour — Thu, 14 Dec 2023 15:28:13 GMT

Hey folks!

I need to calculate the difference between two dates, which normally seems pretty easy.

But now I'm stuck because the dates are in one table field, so like this:

ID | Date | Status
1 | 01.10.2023 | X
1 | 06.11.2023 | Y
1 | 12.12.2023 | Z (done)

So now I want to find the average difference in days between status X and Z (or any other), but I'm having some trouble finding out how to do it.
Normally you would just work with the Avg function and substract the two dates, but I'm not finding the right set expression.

I tried to do something with Aggr, but didn't work out:

Avg(Aggr({$<Status= {'Status X'}>} [Date], [ID]) - Aggr({$<Status = {'Status Z'}>} [Date], [ID]))

Re: Average difference between two dates in same column

rwunderlich — Thu, 14 Dec 2023 15:32:35 GMT

See https://community.qlik.com/t5/QlikView-App-Dev/Comparing-dates-in-the-same-field-in-QV/td-p/487878

-Rob

topic Average difference between two dates in same column in App Development

Average difference between two dates in same column

Re: Average difference between two dates in same column