Qlikview RangeCount or similar

[#1]

Hi Guys,

I am having a situation where i want to set the Result to "Yes"   if  the count of the Criteria 1 is "Yes" in the last consecutive 3 months and also have to group by ID

I have tried the following, but it seems the text in red can't work. Any suggestion, Gurus ?

RangeCount(above(Total Count({<[Criteria1]={'Y'}>}[Criteria1]),0,3))

Eg.

ID          Date      Criteria1  Result

1           1/1/15       Yes

1           1/2/15       Yes

1           1/3/15       Yes       Yes

2           1/1/15       Yes

2           1/2/15       No

2           1/3/15       No        No

Thx in Advanced , Guys

[sunny_talwar]

Please don't repost the same discussion multiple times. I have responded here: Qlikview RangeCount Others have also responded here: Qlivkiew RangeCount with Set Analysis or similar