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.
