topic Re: aggr function in qlikview in QlikView

aggr function in qlikview

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

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 — Mon, 05 Aug 2019 12:17:16 GMT

Try this

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

sunny_talwar — Mon, 05 Aug 2019 12:18:39 GMT

or this

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

rocky147khan — Mon, 05 Aug 2019 12:22:26 GMT

Thank you, both the solutions work.

Infact, the below works as well.

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

Claudiu_Anghelescu — Mon, 05 Aug 2019 12:24:24 GMT

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