topic Re: Repeat Case Analysis - 7days (Above & Below - Dates) in QlikView

topic Re: Repeat Case Analysis - 7days (Above & Below - Dates) in QlikView https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11603#M768426 <HTML><HEAD></HEAD><BODY><P>What is the expected output based on the above sample data?</P></BODY></HTML> Tue, 12 Jun 2018 16:07:49 GMT sunny_talwar 2018-06-12T16:07:49Z Repeat Case Analysis - 7days (Above & Below - Dates) https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11602#M768425 <HTML><HEAD></HEAD><BODY><P>Count of repeat cases for past 7 days and next 7 days interval. count will varry day by day.</P><P></P><P>Example Data:</P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 241px;"><TBODY><TR><TD class="xl63" height="19" width="72">Sn No</TD><TD class="xl63" width="97">Date</TD><TD class="xl63" width="72">Case </TD></TR><TR><TD class="xl63" height="19">1</TD><TD class="xl64">1/1/2018</TD><TD class="xl65">23456</TD></TR><TR><TD class="xl63" height="19">2</TD><TD class="xl64">1/1/2018</TD><TD class="xl63">34567</TD></TR><TR><TD class="xl63" height="19">3</TD><TD class="xl64">1/1/2018</TD><TD class="xl63">67891</TD></TR><TR><TD class="xl63" height="19">4</TD><TD class="xl64">1/1/2018</TD><TD class="xl63">91011</TD></TR><TR><TD class="xl63" height="19">5</TD><TD class="xl64">1/1/2018</TD><TD class="xl63">91011</TD></TR><TR><TD class="xl63" height="19">6</TD><TD class="xl64">1/2/2018</TD><TD class="xl63">01234</TD></TR><TR><TD class="xl63" height="19">7</TD><TD class="xl64">1/2/2018</TD><TD class="xl65">23456</TD></TR><TR><TD class="xl63" height="19">8</TD><TD class="xl64">1/2/2018</TD><TD class="xl63">34567</TD></TR><TR><TD class="xl63" height="19">9</TD><TD class="xl64">1/2/2018</TD><TD class="xl63">67891</TD></TR><TR><TD class="xl63" height="19">10</TD><TD class="xl64">1/2/2018</TD><TD class="xl63">91011</TD></TR><TR><TD class="xl63" height="19">11</TD><TD class="xl64">1/2/2018</TD><TD class="xl63">131415</TD></TR><TR><TD class="xl63" height="19">12</TD><TD class="xl64">1/3/2018</TD><TD class="xl65">23456</TD></TR><TR><TD class="xl63" height="19">13</TD><TD class="xl64">1/3/2018</TD><TD class="xl63">34567</TD></TR><TR><TD class="xl63" height="19">14</TD><TD class="xl64">1/3/2018</TD><TD class="xl63">89101</TD></TR><TR><TD class="xl63" height="19">15</TD><TD class="xl64">1/3/2018</TD><TD class="xl63">89101</TD></TR><TR><TD class="xl63" height="19">16</TD><TD class="xl64">1/3/2018</TD><TD class="xl63">91011</TD></TR><TR><TD class="xl63" height="19">17</TD><TD class="xl64">1/3/2018</TD><TD class="xl63">131415</TD></TR><TR><TD class="xl63" height="19">18</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">01234</TD></TR><TR><TD class="xl63" height="19">19</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">01234</TD></TR><TR><TD class="xl63" height="19">20</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">12345</TD></TR><TR><TD class="xl63" height="19">21</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">67891</TD></TR><TR><TD class="xl63" height="19">22</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">89101</TD></TR><TR><TD class="xl63" height="19">23</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">91011</TD></TR><TR><TD class="xl63" height="19">24</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">111213</TD></TR><TR><TD class="xl63" height="19">25</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">121314</TD></TR><TR><TD class="xl63" height="19">26</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">141516</TD></TR><TR><TD class="xl63" height="19">27</TD><TD class="xl64">1/4/2018</TD><TD class="xl63">151617</TD></TR><TR><TD class="xl63" height="19">28</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">12345</TD></TR><TR><TD class="xl63" height="19">29</TD><TD class="xl64">1/5/2018</TD><TD class="xl65">23456</TD></TR><TR><TD class="xl63" height="19">30</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">45678</TD></TR><TR><TD class="xl63" height="19">31</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">56789</TD></TR><TR><TD class="xl63" height="19">32</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">78910</TD></TR><TR><TD class="xl63" height="19">33</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">111213</TD></TR><TR><TD class="xl63" height="19">34</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">121314</TD></TR><TR><TD class="xl63" height="19">35</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">131415</TD></TR><TR><TD class="xl63" height="19">36</TD><TD class="xl64">1/5/2018</TD><TD class="xl63">141516</TD></TR><TR><TD class="xl63" height="19">37</TD><TD class="xl64">1/6/2018</TD><TD class="xl63">45678</TD></TR><TR><TD class="xl63" height="19">38</TD><TD class="xl64">1/6/2018</TD><TD class="xl63">56789</TD></TR><TR><TD class="xl63" height="19">39</TD><TD class="xl64">1/6/2018</TD><TD class="xl63">89101</TD></TR><TR><TD class="xl63" height="19">40</TD><TD class="xl64">1/6/2018</TD><TD class="xl63">101112</TD></TR><TR><TD class="xl63" height="19">41</TD><TD class="xl64">1/6/2018</TD><TD class="xl63">101112</TD></TR><TR><TD class="xl63" height="19">42</TD><TD class="xl64">1/6/2018</TD><TD class="xl63">121314</TD></TR><TR><TD class="xl63" height="19">43</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">12345</TD></TR><TR><TD class="xl63" height="19">44</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">45678</TD></TR><TR><TD class="xl63" height="19">45</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">45678</TD></TR><TR><TD class="xl63" height="19">46</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">56789</TD></TR><TR><TD class="xl63" height="19">47</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">56789</TD></TR><TR><TD class="xl63" height="19">48</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">78910</TD></TR><TR><TD class="xl63" height="19">49</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">91011</TD></TR><TR><TD class="xl63" height="19">50</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">131415</TD></TR><TR><TD class="xl63" height="19">51</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">141516</TD></TR><TR><TD class="xl63" height="19">52</TD><TD class="xl64">1/7/2018</TD><TD class="xl63">151617</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11602#M768425 Anonymous 2020-11-25T16:16:04Z Re: Repeat Case Analysis - 7days (Above & Below - Dates) https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11603#M768426 <HTML><HEAD></HEAD><BODY><P>What is the expected output based on the above sample data?</P></BODY></HTML> Tue, 12 Jun 2018 16:07:49 GMT https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11603#M768426 sunny_talwar 2018-06-12T16:07:49Z Re: Repeat Case Analysis - 7days (Above & Below - Dates) https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11604#M768427 <HTML><HEAD></HEAD><BODY><P>Basically need to get a count of cases which is repeated for above and below 7 date (Rolling Days).</P><P>Ex: Case <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">91011 is there on <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">1/1/2018, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">1/2/2018, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">1/3/2018, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">1/4/2018</SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">Date          Case     Count     Day wise Interval Count<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">1/1/2018   91011       1                      4</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">1/2/2018   91011       1                      4</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">1/3/2018   91011       1                      4</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">1/4/2018   91011       1                      4</SPAN></P></BODY></HTML> Wed, 13 Jun 2018 07:00:53 GMT https://community.qlik.com/t5/QlikView/Repeat-Case-Analysis-7days-Above-Below-Dates/m-p/11604#M768427 Anonymous 2018-06-13T07:00:53Z