Not bought report

m4u — Wed, 19 Dec 2012 17:20:21 GMT

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

topic Not bought report in QlikView

Not bought report