# 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?

Tags (1)
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,

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

Regards,

Kaushik Solanki

Not applicable

Kaushik,