aggr function in qlikview

[rocky147khan]

Hi All,

The below statement gives me the hyphenated list of all the Customers with Sales greater than 200

=concat(if(aggr(sum(SalesValue),Customer) >200,Customer),'-')

What should I do to get the count of the customers rather than the list.

Thanks in advance.

Regards,

Amjad

[sunny_talwar · Accepted solution]

Try this

=Count(DISTINCT {<Customer = {"=Sum(SalesValue) > 200"}>} Customer)

[sunny_talwar]

or this

=Count(DISTINCT Aggr(If(Sum(SalesValue) > 200, Customer), Customer))

[rocky147khan]

Thank you, both the solutions work.

Infact, the below works as well.

=count(if(aggr(sum(SalesValue),Customer) >200,Customer))

[Claudiu_Anghelescu]

=Count(IF(Aggr(sum(SalesValue),Customer)>200, DISTINCT Customer))