topic Current and previous day count in QlikView https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344228#M127128 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Once again I need your help. Please have a look at this small data set in the file attached. I have daily excution results and want to calculate the difference between the current and the previous day. </P><P></P><P>Or easier, just to get a table that can calculate "Current (execution date)"-"Previous (execution date-1)" and display it in the same row as the current day is.</P><P></P><P>It shall work simillar to stock calculation, displaying the diff to tomorrow, but my data is organized as it is in the load scrip.</P><P></P><P>Is there a easy way to do this?</P><P></P><P>Thank you in advance. Best regards. Lukas</P></BODY></HTML> Wed, 09 May 2012 13:06:24 GMT 2012-05-09T13:06:24Z Current and previous day count https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344228#M127128 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Once again I need your help. Please have a look at this small data set in the file attached. I have daily excution results and want to calculate the difference between the current and the previous day. </P><P></P><P>Or easier, just to get a table that can calculate "Current (execution date)"-"Previous (execution date-1)" and display it in the same row as the current day is.</P><P></P><P>It shall work simillar to stock calculation, displaying the diff to tomorrow, but my data is organized as it is in the load scrip.</P><P></P><P>Is there a easy way to do this?</P><P></P><P>Thank you in advance. Best regards. Lukas</P></BODY></HTML> Wed, 09 May 2012 13:06:24 GMT https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344228#M127128 2012-05-09T13:06:24Z Re: Current and previous day count https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344229#M127129 <HTML><HEAD></HEAD><BODY><P>in second expression use </P><P></P><P>=above(Count(ID))</P><P></P><P></P><P></P><P>see the attched file</P><P></P><P>hope this helps</P></BODY></HTML> Wed, 09 May 2012 13:17:24 GMT https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344229#M127129 SunilChauhan 2012-05-09T13:17:24Z Current and previous day count https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344230#M127130 <HTML><HEAD></HEAD><BODY><P>Thank you soo much.</P><P></P><P>Best regards. Lukas</P></BODY></HTML> Wed, 09 May 2012 13:35:00 GMT https://community.qlik.com/t5/QlikView/Current-and-previous-day-count/m-p/344230#M127130 2012-05-09T13:35:00Z