topic Count Between 2 intervals in 2 dates in QlikView https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256661#M585738 <HTML><HEAD></HEAD><BODY><P>Hellow,</P><P>In my Qvd i have data for 8 days. I built a table like this one.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>eard</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Last Week</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Today</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>%</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>4</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P><BR />I want to show in the table in the column Today the count of the last 3 hour and to compare to last week same 3 hours without any selections.</P><P></P><P>Any help will be appreciated.</P><P></P><P>Tnx</P><P></P><P>Ariel</P></BODY></HTML> Mon, 08 Aug 2011 14:42:28 GMT 2011-08-08T14:42:28Z Count Between 2 intervals in 2 dates https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256661#M585738 <HTML><HEAD></HEAD><BODY><P>Hellow,</P><P>In my Qvd i have data for 8 days. I built a table like this one.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>eard</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Last Week</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Today</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>%</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>3</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>4</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P><BR />I want to show in the table in the column Today the count of the last 3 hour and to compare to last week same 3 hours without any selections.</P><P></P><P>Any help will be appreciated.</P><P></P><P>Tnx</P><P></P><P>Ariel</P></BODY></HTML> Mon, 08 Aug 2011 14:42:28 GMT https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256661#M585738 2011-08-08T14:42:28Z Count Between 2 intervals in 2 dates https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256662#M585739 <HTML><HEAD></HEAD><BODY><P>Hi arielkl1,</P><P></P><P>You have any sample file or data for that i understand your requirements.</P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Mon, 08 Aug 2011 15:42:06 GMT https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256662#M585739 its_anandrjs 2011-08-08T15:42:06Z Re: Count Between 2 intervals in 2 dates https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256663#M585740 <HTML><HEAD></HEAD><BODY><P>Hii <SPAN style="font-family: 'Arial','sans-serif'; color: #333333; font-size: 9pt;">Anand</SPAN></P><P>See the attached file.</P><P></P><P>Tnx</P><P>Ariel</P></BODY></HTML> Tue, 09 Aug 2011 04:24:45 GMT https://community.qlik.com/t5/QlikView/Count-Between-2-intervals-in-2-dates/m-p/256663#M585740 2011-08-09T04:24:45Z