Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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