topic Question regarding Accumulative Sums in QlikView https://community.qlik.com/t5/QlikView/Question-regarding-Accumulative-Sums/m-p/848903#M297850 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a scenario I'm trying to solve. I have one column with timestamps for when someone walks into a "room" and another column when someone walks out. I need to be able to calculate how many ppl are in the room at any given moment. I have connected a master calendar to the set-up.</P><P></P><P>A Timestamp = 1 event. Several events occur per day. I was thinking of keeping it simple and calculate the net number of events per day.</P><P></P><P>Therefore,</P><P>I need to calculate the accumulated number of events up-to the day I choose in the calender and I need it to change automatically when day is changed in the calender.</P><P></P><P></P><P>Thank you very much for and any help.</P></BODY></HTML> Wed, 13 May 2015 09:04:02 GMT 2015-05-13T09:04:02Z Question regarding Accumulative Sums https://community.qlik.com/t5/QlikView/Question-regarding-Accumulative-Sums/m-p/848903#M297850 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a scenario I'm trying to solve. I have one column with timestamps for when someone walks into a "room" and another column when someone walks out. I need to be able to calculate how many ppl are in the room at any given moment. I have connected a master calendar to the set-up.</P><P></P><P>A Timestamp = 1 event. Several events occur per day. I was thinking of keeping it simple and calculate the net number of events per day.</P><P></P><P>Therefore,</P><P>I need to calculate the accumulated number of events up-to the day I choose in the calender and I need it to change automatically when day is changed in the calender.</P><P></P><P></P><P>Thank you very much for and any help.</P></BODY></HTML> Wed, 13 May 2015 09:04:02 GMT https://community.qlik.com/t5/QlikView/Question-regarding-Accumulative-Sums/m-p/848903#M297850 2015-05-13T09:04:02Z