topic Re: Qlikview RangeCount in QlikView

Qlikview RangeCount

Mon, 07 Dec 2015 08:03:55 GMT

Hi Guys,

Can any one help me out , please.

I am having a situation where i want to set the Result to "Yes" when there are "Y" in Criteria in 3 consecutive months and which group by ID.

eg.

ID Date Criteria Result

1 1/1/15 Y

1 1/2/15 Y

1 1/3/15 Y Yes (1/1/15, 1/2/15 and 1/3/15 are Y in Criteria)

1 1/4/15 Y Yes (1/2/15, 1/3/15 and 1/4/2015 are are Y in Criteria)

1 1/5/15 (Result resume = No as the Criteria of 1/5/15 is null)

2 1/1/15 Y

2 1/2/15

2 1/3/15 (1/2/15 is nll, so the result is null)

I have tried below, but it doesn't work

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

Thanks in Advance, Gurus

sunny_talwar — Mon, 07 Dec 2015 19:05:20 GMT

Try this may be:

=If(RangeSum(If(Criteria = 'Y', 1, 0), If(Above(TOTAL Criteria) = 'Y', 1, 0), If(Above(TOTAL Criteria, 2) = 'Y', 1, 0)) = 3, 'Yes')

Tue, 08 Dec 2015 02:24:59 GMT

thx Sunny, but i got this instead

sunny_talwar — Tue, 08 Dec 2015 13:35:31 GMT

Do you just have ID as dimension or ID, Date and Criteria as your dimension?

Tue, 08 Dec 2015 13:38:17 GMT

oh, yes. That's it.

it works now.

Thx Sunny

maxgro — Tue, 08 Dec 2015 14:13:03 GMT

maybe a check as

ID&Criteria & Above(TOTAL ID&Criteria) & Above(TOTAL ID&Criteria, 2)

=Repeat(ID&Criteria,3)

sunny_talwar — Tue, 08 Dec 2015 15:04:20 GMT

Great