topic how to count items that fall between dates? in QlikView

topic how to count items that fall between dates? in QlikView https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525113#M196206 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="209"><TBODY><TR><TD height="20" width="82">workorder #</TD><TD width="127">scheduled finished</TD></TR><TR><TD align="right" height="20">100</TD><TD align="right" class="xl63">8/4/2013</TD></TR><TR><TD align="right" height="20">101</TD><TD align="right" class="xl63">8/5/2013</TD></TR><TR><TD align="right" height="20">102</TD><TD align="right" class="xl63">8/6/2013</TD></TR><TR><TD align="right" height="20">103</TD><TD align="right" class="xl63">8/7/2013</TD></TR><TR><TD align="right" height="20">104</TD><TD align="right" class="xl63">8/8/2013</TD></TR><TR><TD align="right" height="20">105</TD><TD align="right" class="xl63">8/9/2013</TD></TR><TR><TD align="right" height="20">106</TD><TD align="right" class="xl63">8/10/2013</TD></TR><TR><TD align="right" height="20">107</TD><TD align="right" class="xl63">8/11/2013</TD></TR><TR><TD align="right" height="20">108</TD><TD align="right" class="xl63">8/12/2013</TD></TR><TR><TD align="right" height="20">109</TD><TD align="right" class="xl63">8/13/2013</TD></TR><TR><TD align="right" height="20">110</TD><TD align="right" class="xl63">8/14/2013</TD></TR><TR><TD align="right" height="20">111</TD><TD align="right" class="xl63">8/15/2013</TD></TR><TR><TD align="right" height="20">112</TD><TD align="right" class="xl63">8/16/2013</TD></TR><TR><TD align="right" height="20">113</TD><TD align="right" class="xl63">8/17/2013</TD></TR><TR><TD align="right" height="20">114</TD><TD align="right" class="xl63">8/18/2013</TD></TR><TR><TD align="right" height="20">115</TD><TD align="right" class="xl63">8/19/2013</TD></TR><TR><TD align="right" height="20">116</TD><TD align="right" class="xl63">8/20/2013</TD></TR><TR><TD align="right" height="20">117</TD><TD align="right" class="xl63">8/21/2013</TD></TR><TR><TD align="right" height="20">118</TD><TD align="right" class="xl63">8/22/2013</TD></TR></TBODY></TABLE><P></P><P>i need to be able to count the number of work orders completed from 7-14 days from the previous Sunday, so dates 8/4-8/11</P></BODY></HTML> Fri, 23 Aug 2013 13:11:58 GMT 2013-08-23T13:11:58Z how to count items that fall between dates? https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525113#M196206 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="209"><TBODY><TR><TD height="20" width="82">workorder #</TD><TD width="127">scheduled finished</TD></TR><TR><TD align="right" height="20">100</TD><TD align="right" class="xl63">8/4/2013</TD></TR><TR><TD align="right" height="20">101</TD><TD align="right" class="xl63">8/5/2013</TD></TR><TR><TD align="right" height="20">102</TD><TD align="right" class="xl63">8/6/2013</TD></TR><TR><TD align="right" height="20">103</TD><TD align="right" class="xl63">8/7/2013</TD></TR><TR><TD align="right" height="20">104</TD><TD align="right" class="xl63">8/8/2013</TD></TR><TR><TD align="right" height="20">105</TD><TD align="right" class="xl63">8/9/2013</TD></TR><TR><TD align="right" height="20">106</TD><TD align="right" class="xl63">8/10/2013</TD></TR><TR><TD align="right" height="20">107</TD><TD align="right" class="xl63">8/11/2013</TD></TR><TR><TD align="right" height="20">108</TD><TD align="right" class="xl63">8/12/2013</TD></TR><TR><TD align="right" height="20">109</TD><TD align="right" class="xl63">8/13/2013</TD></TR><TR><TD align="right" height="20">110</TD><TD align="right" class="xl63">8/14/2013</TD></TR><TR><TD align="right" height="20">111</TD><TD align="right" class="xl63">8/15/2013</TD></TR><TR><TD align="right" height="20">112</TD><TD align="right" class="xl63">8/16/2013</TD></TR><TR><TD align="right" height="20">113</TD><TD align="right" class="xl63">8/17/2013</TD></TR><TR><TD align="right" height="20">114</TD><TD align="right" class="xl63">8/18/2013</TD></TR><TR><TD align="right" height="20">115</TD><TD align="right" class="xl63">8/19/2013</TD></TR><TR><TD align="right" height="20">116</TD><TD align="right" class="xl63">8/20/2013</TD></TR><TR><TD align="right" height="20">117</TD><TD align="right" class="xl63">8/21/2013</TD></TR><TR><TD align="right" height="20">118</TD><TD align="right" class="xl63">8/22/2013</TD></TR></TBODY></TABLE><P></P><P>i need to be able to count the number of work orders completed from 7-14 days from the previous Sunday, so dates 8/4-8/11</P></BODY></HTML> Fri, 23 Aug 2013 13:11:58 GMT https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525113#M196206 2013-08-23T13:11:58Z Re: how to count items that fall between dates? https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525114#M196207 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Fri, 23 Aug 2013 13:27:56 GMT https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525114#M196207 Gysbert_Wassenaar 2013-08-23T13:27:56Z Re: how to count items that fall between dates? https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525115#M196208 <HTML><HEAD></HEAD><BODY><P>when i try implementing the solution for another problem the max date i'm getting is from 2019 is there a way to limit modify the solution</P><P>for example</P><P></P><TABLE><TBODY><TR><TD>workorder #</TD><TD>scheduled finished</TD><TD>Day</TD></TR><TR><TD>100</TD><TD>8/4/2013</TD><TD>sun</TD></TR><TR><TD>101</TD><TD>8/5/2013</TD><TD>mon</TD></TR><TR><TD>102</TD><TD>8/6/2013</TD><TD>tue</TD></TR><TR><TD>103</TD><TD>8/7/2013</TD><TD>wed</TD></TR><TR><TD>104</TD><TD>8/8/2013</TD><TD>thu</TD></TR><TR><TD>105</TD><TD>8/9/2013</TD><TD>fri</TD></TR><TR><TD>106</TD><TD>8/10/2013</TD><TD>sat</TD></TR><TR><TD>107</TD><TD>8/11/2013</TD><TD>sun</TD></TR><TR><TD>108</TD><TD>8/12/2013</TD><TD>mon</TD></TR><TR><TD>109</TD><TD>8/13/2013</TD><TD>tue</TD></TR><TR><TD>110</TD><TD>8/14/2013</TD><TD>wed</TD></TR><TR><TD>111</TD><TD>8/15/2013</TD><TD>thu</TD></TR><TR><TD>112</TD><TD>8/16/2013</TD><TD>fri</TD></TR><TR><TD>113</TD><TD>8/17/2013</TD><TD>sat</TD></TR><TR><TD>114</TD><TD>8/18/2013</TD><TD>sun</TD></TR><TR><TD>115</TD><TD>8/19/2013</TD><TD>mon</TD></TR><TR><TD>116</TD><TD>8/20/2013</TD><TD>tue</TD></TR><TR><TD>117</TD><TD>8/21/2013</TD><TD>wed</TD></TR><TR><TD>118</TD><TD>8/22/2013</TD><TD>thu</TD></TR><TR><TD>119</TD><TD>8/23/2013</TD><TD>fri</TD></TR><TR><TD>120</TD><TD>8/24/2013</TD><TD>sat</TD></TR><TR><TD>121</TD><TD>8/25/2013</TD><TD>sun</TD></TR><TR><TD>122</TD><TD>8/26/2013</TD><TD>mon</TD></TR><TR><TD>123</TD><TD>8/27/2013</TD><TD>tue</TD></TR><TR><TD>124</TD><TD>8/28/2013</TD><TD>wed</TD></TR><TR><TD>125</TD><TD>8/29/2013</TD><TD>thu</TD></TR><TR><TD>126</TD><TD>8/30/2013</TD><TD>fri</TD></TR></TBODY></TABLE><P></P><P>With this data i still only want data back 7-14 days from 8/18/2013</P></BODY></HTML> Fri, 23 Aug 2013 15:06:03 GMT https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525115#M196208 2013-08-23T15:06:03Z Re: Re: how to count items that fall between dates? https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525116#M196209 <HTML><HEAD></HEAD><BODY><P>See attached example</P></BODY></HTML> Fri, 23 Aug 2013 16:16:51 GMT https://community.qlik.com/t5/QlikView/how-to-count-items-that-fall-between-dates/m-p/525116#M196209 Gysbert_Wassenaar 2013-08-23T16:16:51Z