Discussion Board for collaboration on QlikView Layout & Visualizations.
How to calculate the average number of days between two dates in qlikview?
Do you mean the difference between two days?
If yes then try below expression.
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.
Will you please upload the qvw file.
I am not sure, but if you can send the file, i can try something.
I uploaded the (Test1)qvw file above. please verify and let me know your inputs.