Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Luminary
Luminary

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

View solution in original post

2 Replies
Highlighted
Luminary
Luminary

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

View solution in original post

Not applicable

Counting days between selection in calendar

Thanks that worked very good.