Crosselling

[fkeuroglian]

Hi experts

i am creating a crosselling in qlikview and i have a problem

the data is distribute in one table and one client could have more than one product

Client     Producto

A                1

B                2

C                3

A                2

B                3

the crosselling works ok, but if i have and do some kind of filtres such as:

See clients that have product 1 but NOT HAVE product 2, do not works ok and looks like my solution do not work

attached and image to get the example

i have trie with the AND MODE and the list panel work like that,

thank you a lot

what do you think could be a would solution?

[marcus_sommer]

The and-mode is one possibility but needs some requirements AND-Mode / AND and OR and another approach could be a set analysis expression, maybe like this one:

sum({< Products = {'product1'}, Products -= {'product2'}>} value)

- Marcus