topic Re: List of clients who buy product A and not B in QlikView

List of clients who buy product A and not B

Tue, 18 Dec 2012 09:40:14 GMT

Hi !

Just a little question, is it possible in a table to show the client who buy a product A and not the product B.

I select a product A in a list selection, I select a product B in another list selection.

In a table, i want to see the clients who buy the product A and not the B

Thanks

regards,

Adrian

Re: List of clients who buy product A and not B

Miguel_Angel_Baeyens — Tue, 18 Dec 2012 10:25:19 GMT

Hi Adrian,

Using the element P() and E() functions in set analysis you will get it:

Sum({< Customer = E({< ProdID = {'B'} >} Customer) >} Amount)

Hope that helps.

Miguel

Re: List of clients who buy product A and not B

Tue, 18 Dec 2012 10:26:53 GMT

Hi!!

It's possible to do that using an expression in a Straight Table Chart. In this chart you should select Client dimension and create the next expression.

sum({<product = {A}, product -= {B}>} number_of_clients)

Result:

Client1 1

Client2 1

... 1

ClienteN 1

Now you can hide the number_of_clients column if you want.

Jairo

Re: List of clients who buy product A and not B

Tue, 18 Dec 2012 12:53:43 GMT

thanks a lot for your answers !

well, i didn't know the function P() and E() and there are easy to use.

I have another question, and i don't know if it's possible or not.

Users want to select in a list box a product A and in another one a product B.The result will be in a table and list clients

- who buy the product A

- and didn't buy the product B

Any ideas ?

thanks you a lot !

Re: List of clients who buy product A and not B

Tue, 18 Dec 2012 13:06:06 GMT

The difference between your example and what user want, is in the set analysis : you write in code Product B but how is it possible to change this and let the user to decide with unsig a selection box ?

Re: List of clients who buy product A and not B

thomduvi83 — Tue, 18 Dec 2012 13:33:55 GMT

You should have a look to the "AND mode" for the list boxes.

In that mode, if you select 2 products, it will show you the clients who have bought product1 AND product2, not the clients who have bought product1 OR product2.

If you click longer on a product, you can exclude it (clients that have bought product 1 AND not product 2) --> RED color in Qlikview !

Look at this small example, then at the help menu for how to set up a table in "and mode".

Regards,

Thomas

Re: List of clients who buy product A and not B

Tue, 18 Dec 2012 14:19:42 GMT

waouh i had never seen that before (click longer to exclude !)

thanks a lot again !

Re: List of clients who buy product A and not B

Fri, 26 Jul 2013 10:24:00 GMT

i want deep explain can u pls send me profect process in this answer pls provide me bro

Re: List of clients who buy product A and not B

Fri, 26 Jul 2013 10:28:12 GMT

thanku jairo