Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Occupancy rate for real estate

Dear experts,

I have a problem with calculating occupancy rate for a real estate.

I have different houses which have multiple start and end dates for renting periods.

House_IDStart_dateEnd_date
15.5.200627.1.2010
11.4.201031.10.2010
121.12.201030.11.2011
11.12.201131.7.2012
115.12.2012-
210.10.200628.2.2013
21.4.20131.9.2013
21.2.201420.10.2014
.........

Now I need to calculate the occupancy rate of the flat per every year. (Which means the number of days house hasn't been rented in a year)

Any ideas how to do this?

Thank you!

-Mikael

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi there.

See the document attached. I generated all "missing" dates between the start/end dates, learned this technique from the excellent "Generating missing data in QlikView" document by Henric Cronström available in the Resources section.

The only catch is I had to hard-code the current date for record 5 in the INLINE statement because actual start/end date values are needed, you can fill those up using IF(), ISNULL() and TODAY() in your script.

Kind regards,

Ernesto.

View solution in original post

3 Replies
Highlighted
Partner
Partner

Hi MiKael,

The Networkdays() function would be useful.

See the description and the link below:

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

http://community.qlik.com/message/407267#407267

Have fun with QV,

François

Highlighted
Partner
Partner

Hi there.

See the document attached. I generated all "missing" dates between the start/end dates, learned this technique from the excellent "Generating missing data in QlikView" document by Henric Cronström available in the Resources section.

The only catch is I had to hard-code the current date for record 5 in the INLINE statement because actual start/end date values are needed, you can fill those up using IF(), ISNULL() and TODAY() in your script.

Kind regards,

Ernesto.

View solution in original post

Highlighted
Not applicable

Exactly what I was looking for. Thank you Ernesto and happy holidays!