topic sale issue in QlikView

sale issue

Fri, 10 Oct 2014 11:26:55 GMT

Scenario

Purchased

customer who bought the product a

customer id product id

1 1

1 4

2 2

3 4

Product id Product

1 a

2 b

3 a

4 c

not Purchases

customer who had not bot the product b

Product id Product

1 a

2 b

3 a

4 c

1. i need customer who had not purchase the product b and customer who purchased product a, i am having two set analytics group called NOTPurchase and Purchase.

I am using the following formula to find the solution.

sum({<CustId-={"[NOTPurchase]::CustId"},CustId=[Purchase]::CustId>}saletotal)

Re: sale issue

PrashantSangle — Fri, 10 Oct 2014 11:47:27 GMT

Hi,

Please find attached apps.

Might be as per your requirement.

Regards

Re: sale issue

Fri, 10 Oct 2014 11:57:10 GMT

Thanks max, But i need to implement with the set analytics only. product 1 listbox should not link with with product 2 list box. but both data are getting from the same table

product 1 table <Purchase >(Set Analytics)

product 2 table <NotPurchase >(Set Analytics)

Re: sale issue

jyothish8807 — Fri, 10 Oct 2014 11:57:40 GMT

Hi Srini,

May it work;

Purchase:
LOAD * INLINE [
Customerid,Productid
1,1
1,4
2,2
3,4
];

Product:
LOAD * INLINE [
Productid,Product
1,a
2,b
3,a
4,c
];

NoConcatenate
TestPurchase:
Load * Resident Purchase;

join
load * Resident Product
where Product = 'a' and Product <> 'b';

DROP Tables Purchase,Product;

Regards

Re: sale issue

Fri, 10 Oct 2014 12:59:12 GMT

I am getting these two tables from the database. all these selection are dynamic. user want to see the customers who purchased one project and not purchased other product, say for example consider the soap park avenue green purchased by set of customers and park avenue blue not purchased by the customers.