Hi all,
I have qlikview sales module that holds the following tables:
items (all items the company sales)
customers (all company customers)
sales (sale documents linkes between a customer an item and transaction details)
Now I have to create a report that shows all customers vertically and all items horizontally and an expression that specifies if the customer bought the item or not, for example:
Customer/Prodduct | Pdouct 1
| Product 2
| Product 3 | Product 4 |
---|
Customer A | X | X | V | X |
Customer B | X | X | X | X |
Customer C | Y | Y | Y | Y |
I try to create a pivot table with Customer,Product dimensions and this expression: =if(sum(LineTotal)>0,'V','X')
but the problem is that if a customer doesn't bought any product for the selected period, the customer will not be displayed on my report.
if I use "show all values" for my dimensions, the expression is not working well.
do you have any Idea for me?
meany thanks
shlomo