Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kolov007
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
MK_QSL
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
MK_QSL
MVP
MVP

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

kolov007
Contributor III
Contributor III
Author

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

MK_QSL
MVP
MVP

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

kolov007
Contributor III
Contributor III
Author

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

MK_QSL
MVP
MVP

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

MK_QSL
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

kolov007
Contributor III
Contributor III
Author

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

MK_QSL
MVP
MVP

Can you please close the thread by selecting appropriate answer?

Thanks

kolov007
Contributor III
Contributor III
Author

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