Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Set Analysis

Hello.

I have a base with sales base. I need to count the number of outlets to sell the product 41 in the amount of > = 2,  it is necessary that the sample be in the field of business fields and the product is not made.

Help me please.

Screenshot_1.jpgScreenshot_2.jpg

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

or

COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

View solution in original post

15 Replies
Highlighted
MVP
MVP

What could be the output table or result you are looking for?

Highlighted
Contributor III
Contributor III

Instead of 10 should be 2 (with no samples in Current Selections)Screenshot_3.jpg

Highlighted
MVP
MVP

COUNT({<Adress_Id = {"=SUM(Quantity)>=2"}>}DISTINCT Adress_Id)

Highlighted
Contributor III
Contributor III

I need that displays the number of outlets that shipped more than 2 units only Product 41 (Product_Id]={"1033"})

Highlighted
MVP
MVP

COUNT({<[Product_Id]={'1033'}, Adress_Id = {"=SUM({1<[Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

Highlighted
MVP
MVP

or

COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you very much

COUNT({<Product=, Business=, [Product_Id]={'1033'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1033'}>}Quantity)>=2"}>}DISTINCT Adress_Id)

This is exactly what I need

Highlighted
MVP
MVP

Can you please close the thread by selecting appropriate answer?

Thanks

Highlighted
Contributor III
Contributor III

And please tell me even if you do not difficult, if I need that there were two conditions: count the number of outlets in which the goods were shipped product 41> = 2 and product 42> = 1