topic Re: A total on the function if in QlikView

A total on the function if

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table by customer code on which I managed to calculate the number of new customers. The objective is to get only this sum in an object without the table of details.

Min_date= aggr( min({<Date=>} Date),[Code Client])

New = if (aggr( min({<Date=>} Date),[Code Client])<AddMonths(vDateDébut,-24), 1, 0)

Thank you for your help

Re: A total on the function if

sunny_talwar — Thu, 29 Jun 2017 12:53:16 GMT

May be this

Sum(Aggr(If(Min({<Date=>} Date) < AddMonths(vDateDébut,-24), 1, 0), [Code Client]))

Re: A total on the function if

sunny_talwar — Thu, 29 Jun 2017 12:54:14 GMT

Or may be this

Sum(If(Aggr(Min({<Date=>} Date), [Code Client]) < AddMonths(vDateDébut,-24), 1, 0))

Re: A total on the function if

Anonymous — Thu, 29 Jun 2017 13:57:29 GMT

Thanks lot for your help it's work