4 Replies Latest reply: Apr 23, 2013 3:12 PM by Saranya Dhamodharan

# Average No of Days

Hi,

How to calculate the average number of days between two dates in qlikview?

• ###### Re: Average No of Days

Hi,

Do you mean the difference between two days?

If yes then try below expression.

Interval(Date1-Date2 ,'D')

Regards,

Kaushik Solanki

• ###### Re: Average No of Days

Thanks Kaushik.

Can you help me with another scenario?

I have five different date fields and I want to show the Average Number of days between each date field in bar chart. Here is what I am looking for.

X-Axis = Avg(Interval(Date2-Date1)), Avg(Interval(Date3-Date2)), Avg(Interval(Date4-Date3))

Y-axis = No of days(0,5,10,50)

How can I achieve this? Your help is very much appreciated.

• ###### Re: Average No of Days

Hi,

Will you please upload the qvw file.

I am not sure, but if you can send the file, i can try something.

Regards,

Kaushik Solanki

• ###### Re: Average No of Days

Kaushik,

I uploaded the (Test1)qvw file above. please verify and let me know your inputs.

Thanks