Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

Set expression

Hi Experts,

Pic.PNG

From this table find out the product where count(sales) >0

How to write the set expression for that?

Thanks In advance

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Count({<Product={"=Count(sales)>1"}>}Product)

View solution in original post

6 Replies
prabhas277
Creator
Creator
Author

Sorry

Find out the product where count(sales)>1

sunny_talwar

May be this

Count(DISTINCT {<product = {"=Count(Sales) > 1"}>}product)

ariel_klien
Specialist
Specialist

Hi,

did you try if(count(sales)>0,1,0)

Ariel

tresesco
MVP
MVP

Count({<Product={"=Count(sales)>1"}>}Product)

prabhas277
Creator
Creator
Author

For that I am getting output 0

sunny_talwar

May be your field name is sales and not Sales... have you made sure that the field names are read correct?

Count(DISTINCT {<product = {"=Count(sales) > 1"}>}product)