topic Qlikview RangeCount or similar in QlikView https://community.qlik.com/t5/QlikView/Qlikview-RangeCount-or-similar/m-p/960835#M950044 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi Guys,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am having a situation where i want to set the Result to "Yes"&nbsp;&nbsp; if&nbsp; the count of the Criteria 1 is "Yes" in the last consecutive 3 months and also have to group by ID</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have tried the following, but it seems the text in red can't work. Any suggestion, Gurus ?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">RangeCount(above(Total Count({&lt;<SPAN style="color: #ff0000;">[Criteria1]={'Y'}</SPAN>&gt;}[<SPAN style="font-size: 13.3333px;">Criteria1</SPAN>]),0,3))</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Eg.</P><P style="font-size: 13.3333px;">ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Criteria1&nbsp; Result</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/2/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/3/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #0000ff;">Yes</STRONG></P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/2/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/3/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #0000ff; font-size: 13.3333px;">No</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thx in Advanced , Guys</P></BODY></HTML> Mon, 07 Dec 2015 05:21:12 GMT 2015-12-07T05:21:12Z Qlikview RangeCount or similar https://community.qlik.com/t5/QlikView/Qlikview-RangeCount-or-similar/m-p/960835#M950044 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi Guys,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am having a situation where i want to set the Result to "Yes"&nbsp;&nbsp; if&nbsp; the count of the Criteria 1 is "Yes" in the last consecutive 3 months and also have to group by ID</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have tried the following, but it seems the text in red can't work. Any suggestion, Gurus ?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">RangeCount(above(Total Count({&lt;<SPAN style="color: #ff0000;">[Criteria1]={'Y'}</SPAN>&gt;}[<SPAN style="font-size: 13.3333px;">Criteria1</SPAN>]),0,3))</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Eg.</P><P style="font-size: 13.3333px;">ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Criteria1&nbsp; Result</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/2/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/3/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #0000ff;">Yes</STRONG></P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Yes</P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/2/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No</P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/3/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #0000ff; font-size: 13.3333px;">No</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thx in Advanced , Guys</P></BODY></HTML> Mon, 07 Dec 2015 05:21:12 GMT https://community.qlik.com/t5/QlikView/Qlikview-RangeCount-or-similar/m-p/960835#M950044 2015-12-07T05:21:12Z Re: Qlikview RangeCount or similar https://community.qlik.com/t5/QlikView/Qlikview-RangeCount-or-similar/m-p/960836#M950045 <HTML><HEAD></HEAD><BODY><P>Please don't repost the same discussion multiple times. I have responded here: <A href="https://community.qlik.com/thread/194307">Qlikview RangeCount</A> Others have also responded here: <A href="https://community.qlik.com/thread/194289">Qlivkiew RangeCount with Set Analysis or similar</A></P></BODY></HTML> Mon, 07 Dec 2015 19:46:01 GMT https://community.qlik.com/t5/QlikView/Qlikview-RangeCount-or-similar/m-p/960836#M950045 sunny_talwar 2015-12-07T19:46:01Z