Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Average No of Days

Hi,

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

4 Replies

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

Not applicable

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

Not applicable

Re: Average No of Days

Kaushik,

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

Thanks

Community Browser