topic Re: Urgent Need1 in QlikView

Urgent Need1

Mahamed_Qlik — Wed, 19 Aug 2015 11:38:44 GMT

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 — Wed, 19 Aug 2015 12:46:35 GMT

I think you want something like:

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

Anonymous — Wed, 19 Aug 2015 13:19:47 GMT

Hi Mohammed,

Try:

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

Regards

Neetha

Kushal_Chawda — Wed, 19 Aug 2015 14:04:01 GMT

Please see the attached.

This is what you are looking for?