Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

sale issue

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)

4 Replies

Re: sale issue

Hi,

Please find attached apps.

Might be as per your requirement.

Regards

Regards,
Prashant Sangle
Not applicable

Re: sale issue

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)

jyothish8807
Honored Contributor II

Re: sale issue

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

KC

Best Regards,
KC
Not applicable

Re: sale issue


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.

Community Browser