how to write expression

[kunkumnaveen]

Hi ,

i want to count product which is supplied by only one supplier..

supplier    product       

A              gear

B              gear

C              break

D              glass

E               seat

Answer : 3 because break,glass, seat is supplied by only one supplier

how to write expression ?   plz

Thanks

[antoniotiman · Accepted solution]

Try in text box

=Count(Aggr(If(Count(DISTINCT supplier) = 1,supplier),product))

Regards,

Antonio

[sergio0592]

As expression:

count({<product={"=count(supplier)=1"}>} supplier)

[qlikview979]

May be

=count({<product=P({<product={seat,'glass','break'}>})>}supplier)

[antoniotiman]

is equivalent to

count({<product={seat,'glass','break'}>}supplier)

However the list is hardcoded.

Regards,

Antonio