topic Set Analysis in QlikView

Set Analysis

kolov007 — Tue, 24 Jan 2017 09:10:11 GMT

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.

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 09:14:55 GMT

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

Re: Set Analysis

kolov007 — Tue, 24 Jan 2017 09:37:38 GMT

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

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 09:40:42 GMT

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

Re: Set Analysis

kolov007 — Tue, 24 Jan 2017 09:51:55 GMT

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

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 09:57:38 GMT

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

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 09:59:08 GMT

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

Re: Set Analysis

kolov007 — Tue, 24 Jan 2017 10:03:43 GMT

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

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 10:14:02 GMT

Can you please close the thread by selecting appropriate answer?

Thanks

Re: Set Analysis

kolov007 — Tue, 24 Jan 2017 12:04:26 GMT

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

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 12:06:17 GMT

Not understood... please explain..

Re: Set Analysis

kolov007 — Tue, 24 Jan 2017 12:19:28 GMT

I need the number of outlets that the following conditions product 41> = 2 and product 42> = 1

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 12:28:49 GMT

=COUNT(

{

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

<Product=, Business=, [Product_Id]={'1031'}, Adress_Id = {"=SUM({1<Product=, Business=, [Product_Id]={'1031'}>}Quantity)>=1"}>

}

Adress_Id)

Re: Set Analysis

MK_QSL — Tue, 24 Jan 2017 12:37:52 GMT

Or try this...

=COUNT(

{

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

}

Distinct Adress_Id)

Re: Set Analysis

kolov007 — Fri, 27 Jan 2017 14:27:36 GMT

Thank you

Re: Set Analysis

MK_QSL — Fri, 27 Jan 2017 15:09:54 GMT

Is that worked?