Discussion Board for collaboration related to Creating Analytics for QlikView.
i want to count product which is supplied by only one supplier..
Answer : 3 because break,glass, seat is supplied by only one supplier
how to write expression ? plz
Go to Solution.
Try in text box
=Count(Aggr(If(Count(DISTINCT supplier) = 1,supplier),product))
is equivalent to
However the list is hardcoded.