topic Re: customer with no transaction in QlikView

customer with no transaction

omid5ive — Tue, 09 Jan 2018 14:17:31 GMT

i have a table that show my customers with their buy

i need this

when i click on some product i need a list of customer that they dont buy the selected product

how can i create this list?

it means that when i select 3 in product list i need a list with 100 and 101 customers

tresB — Tue, 09 Jan 2018 14:22:09 GMT

PFA

=Aggr(Only({<product=e(product)>}customer),customer)

sunny_talwar — Tue, 09 Jan 2018 14:25:29 GMT

May be this

Table:

LOAD * INLINE [

customer, product

100, 2

101, 1

100, 1

103, 3

];

Temp:

LOAD Distinct customer

Resident Table;

Left Join (Temp)

LOAD Distinct product

Resident Table;

Left Join (Temp)

LOAD *,

1 as Flag

Resident Table;

FinalTable:

LOAD product,

If(Flag = 1, customer) as customer,

If(Len(Trim(Flag)) = 0, customer) as not_customer

Resident Temp;

DROP Table Table, Temp;

vvvvvvizard — Tue, 09 Jan 2018 14:26:35 GMT

What does the Aggr(Customer , Customer) part do , please explain?

I understand the rest