Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Counting days between selection in calendar

Hi, i am new to this. I am building a pivot table to calculate occupation in an hotel between 2 dates. I already have a pivot table with a column with number of nights sold for every room and also a calendar object to filter the data in the table by dates. I need to add another column that shows the number of days between the 2 days selected on the calendar (set to multiple values), so I can calculate ocuppation (# of nights/# of days selected)*100%).

Any ideas?

Tags (4)
1 Solution

Accepted Solutions
stephen-a_redmo
Valued Contributor II

Counting days between selection in calendar

Might be simplistic but does:

Count(Distinct Date_Key)

[whatever your key for the calendar is called]

Regards,


Stephen

2 Replies
stephen-a_redmo
Valued Contributor II

Counting days between selection in calendar

Might be simplistic but does:

Count(Distinct Date_Key)

[whatever your key for the calendar is called]

Regards,


Stephen

Not applicable

Counting days between selection in calendar

Thanks that worked very good.

Community Browser