topic Re: How to count customers in data set in QlikView

How to count customers in data set

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

I made an expression to compare customers transaction from one month to another:

=if((sum([TransactionAmount]) < 3000)and

(sum(aggr(rangesum(above(total sum({<TransactionMonth=>}TransactionAmount),1,1)),AccountNo,TransactionPeriod))>=3000),1,0)

Now I want to count all the customers, who fullfill this requirement; all the customers that receives a 1 from the expression. How do I solve that? I haven't been able to solve this without getting errors in expression..

Re: How to count customers in data set

Frank_Hartmann — Fri, 28 Jul 2017 15:30:54 GMT

what about this:

=sum(if((sum([TransactionAmount]) < 3000)and

(sum(aggr(rangesum(above(total sum({<TransactionMonth=>}TransactionAmount),1,1)),AccountNo,TransactionPeriod))>=3000),1,0))

Re: How to count customers in data set

Anonymous — Mon, 31 Jul 2017 06:21:26 GMT

This gives me an "Error in expression".

Maybe I need to alter the original expression, to make it work? Any hot tips?

Re: How to count customers in data set

tresB — Mon, 31 Jul 2017 06:42:56 GMT

May be this?

Count(Aggr(

If(sum([TransactionAmount]) < 3000)and

(sum(aggr(rangesum(above(total sum({<TransactionMonth=>}TransactionAmount),1,1)),AccountNo,TransactionPeriod))>=3000), Customer), Customer)