Urgent Need1

[Mahamed_Qlik]

Hello Guys,

I have below given data.

Dealer Code	Month	Quantity	Result
D0001	JAN	30	-
D0001	FEB	40	-
D0001	MAR	50	1
D0002	APR	60	1
D0002	MAY	70	1
D0002	JUN	80	1
D0003	JUL	90	1
D0003	AUG	10	-
D0003	SEP	20	-

In this scenario only Dealer code D0002 should be consider because there is consistent 3 months results(1) is appearing however

for Dealer code D0001 and D003 there is missing of result for few months.

Note :Result is calculated as 1 if quantity is greater than or equal to 50.

So, I need to calculate the sum of distinct dealer code where result is appearing for consistent 3 months.

Kindly suggest.

[richnorris]

I think you want something like:

=if(aggr( sum(Result), [Dealer Code]) >= 3, [Dealer Code])

[Anonymous]

Hi Mohammed,

Try:

=if(aggr( sum(Result), [Dealer Code]) >= 3, [Dealer Code])

Regards

Neetha

[Kushal_Chawda]

Please see the attached.

This is what you are looking for?