Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to calculate the average number of days between two dates in qlikview?
Hi,
Do you mean the difference between two days?
If yes then try below expression.
Interval(Date1-Date2 ,'D')
Regards,
Kaushik Solanki
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.
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
Kaushik,
I uploaded the (Test1)qvw file above. please verify and let me know your inputs.
Thanks