topic Counting days between selection in calendar in QlikView https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264354#M579772 <HTML><HEAD></HEAD><BODY><P>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%). </P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 08 Feb 2012 15:31:07 GMT 2012-02-08T15:31:07Z Counting days between selection in calendar https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264354#M579772 <HTML><HEAD></HEAD><BODY><P>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%). </P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 08 Feb 2012 15:31:07 GMT https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264354#M579772 2012-02-08T15:31:07Z Counting days between selection in calendar https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264355#M579773 <HTML><HEAD></HEAD><BODY><P>Might be simplistic but does:</P><P></P><P>Count(Distinct Date_Key)</P><P></P><P>[whatever your key for the calendar is called]</P><P></P><P></P><P></P><P>Regards,</P><P></P><P></P><P><BR />Stephen</P></BODY></HTML> Wed, 08 Feb 2012 15:34:40 GMT https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264355#M579773 stephencredmond 2012-02-08T15:34:40Z Counting days between selection in calendar https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264356#M579774 <HTML><HEAD></HEAD><BODY><P>Thanks that worked very good.</P></BODY></HTML> Fri, 10 Feb 2012 13:51:21 GMT https://community.qlik.com/t5/QlikView/Counting-days-between-selection-in-calendar/m-p/264356#M579774 2012-02-10T13:51:21Z