Count Function in Qliksense

[anisha_nan]

Hi ,

i am unable to write the below in count function:

Requirement is : In a month, Give me count of addresses where there have been more than one  Product sold.

can anybody help me out with correct expression.

Regards

[goncalo_ricardo_pereira]

If I understand correctly, you can do something like this:
count( {<Product={"=sum(Sales)>0"}>} distinct addresses)
This expression is counting all the distinct addresses where the products have the sum of sales grater then 0...
Regards.
Goncalo Pereira

[Anil_Babu_Samineni]

I think, This helps

Spoiler

count( {<Product={"=Count(Product)>0"}>} addresses)