topic Re: multiple supplier expression in QlikView

multiple supplier expression

kunkumnaveen — Thu, 08 Jun 2017 06:48:13 GMT

Hello,

i want to display count of products which is supplied by only one supplier

load * inline

[

product,supplier

A,XXX

A,YYY

A,ZZZ

B,HHH

B,LLL

C,OOO

L,PPP

];

expression: =Count(Aggr(If(Count( distinct supplier) = 1,supplier),product)) so answer:2 which is correct

now for the same data i am trying to count products which is supplied by multiple supplier

expression: =Count(Aggr(If(Count( distinct supplier) >1,supplier),product)) so answer suppose to be 2 but i am geeting zero

can any help plz.

Thanks

prma7799 — Thu, 08 Jun 2017 06:53:05 GMT

Like this ??

=Count(Aggr(If(Count( distinct supplier) > 0 ,supplier),product))

lironbaram — Thu, 08 Jun 2017 06:53:46 GMT

use this function

=sum(Aggr(if(Count(distinct supplier)>1,1,0),product))

prma7799 — Thu, 08 Jun 2017 06:54:54 GMT

Or you can try

=Count(Aggr(If(Count( distinct supplier) >=1 ,supplier),product))

kunkumnaveen — Thu, 08 Jun 2017 06:56:01 GMT

Thanks for reply,

looks like greater then zero wont work because i need count of only those products which is supplied my multiple vendors or suppliers

prma7799 — Thu, 08 Jun 2017 06:59:07 GMT

Try like this

=sum(Aggr(if(Count(distinct supplier)>1,1,0),product))

Anonymous — Thu, 08 Jun 2017 07:24:33 GMT

Hi,

Please see below. I believe this will work.

=count(if(aggr(count(supplier),product)>1,product))