set analysis operator question

jduluc12 — Mon, 02 Oct 2017 11:59:33 GMT

Hi,

Here is my data set.

Customer	Product	Amount
CustA	Prod_1	100
CustB	Prod_2	200
CustC	Prod_1	300
CustC	Prod_3	100
CustD	Prod_1	20
CustE	Prod_1	200
CustF	Prod_1	100
CustF	Prod_4	100
CustG	Prod_3	400

I need to write an expression something like this

sum ({<Customer={'CustA', 'CustB', 'CustF', 'CustC', 'CustD'}> - <Customer=p({<Product={'Prod2', 'Prod3'}>})>}Amount)

it should return amount of CustA and CustD becasue only these two customers in the first list(in red) have not bought Prod2 and Prod3.

It should not return amount of CustE even though it also have bought Prod2 and Prod3 because it is not in the first list(in red)

The intention is to choose only those customers who are in first list (in red) and those who have not bought products mentioned in the second list (in green).

Re: set analysis operator question

sunny_talwar — Mon, 02 Oct 2017 12:05:22 GMT

Why not include CustF? He hasn't bouth Prod2 or Prod3... may be this

Sum({<Customer={'CustA', 'CustB', 'CustF', 'CustC', 'CustD'}-p({<Product={'Prod_2', 'Prod_3'}>})>}Amount)

Re: set analysis operator question

jduluc12 — Mon, 02 Oct 2017 12:08:18 GMT

You are right.

In fact even my expression worked but yours is more elegant.

topic Re: set analysis operator question in QlikView

set analysis operator question

Re: set analysis operator question

Re: set analysis operator question