Difference between dates

[#1]

Hello,

I have a dataset as follows

HU Status Date

123 12 10/11/2009

123 23 10/13/2009

456 12 12/09/2009

456 23 12/16/2009

What I need to do i put a chart in Qlikview showing average time per HU between status 12 and 23.

i.e for HU 123 - time = 2 days

for HU 456 time = 7 days,

hence average should be 4.5 days

I am struggling to write expressions for this chart..

I have already combined the date parameter to a common selection.

Thanks.

Kiran.

[#2]

Hi Kiran

please see if this is example is helpful to reach your goal.

Good luck!

Rainer

[#3]

Thank you for the reply sir.

I have looked up the Peek() functionality and I have a slight problem on how to make it work for my case. I am sorry that I did not specify that I have multiple status in my data. i.e.

HU Status Date

123 12 10/11/2009

123 13 10/12/2009

123 21 10/12/2009

123 23 10/13/2009

So for this case the peek() formula you have written in the load fails. How do I insert a condition that says when status = 23.

Thanks Again.

Kiran.

[#4 · Accepted solution]

Hi Kiran,

no problem to change the scrip lines for that one.

Good luck!

Rainer

[#5]

wonderful. thank u thank u