Products that customer not bought

[mrbqlik2009]

I have sample data in QlikView such as bellow:

LOAD * INLINE [

CustomerName, ProductTitle, Fee, Quantity, Price

A1,Book1,100,7,700

A1,Book1,100,5,500

B1,Book1,100,3,300

B1,Book2,200,6,1200

B1,Book3,100,3,300

C1,Book3,100,9,900

C1,Book4,200,9,1800

];

i have a listbox for customer and table chart with 2 dimenssion "CustomerName" and "productTitle"  and 1 expression Sum(Quantity).

when i select 1 customer i want display in table product that not bought selected customer and display 0 in sum(quantity).

For example if select customer "A1" in table display "Book3" and "Book4" with sum(Quantity) 0.

[ogautier62]

Hi,

it's native in Qlik,

on your product listbox : select excluded values

or if you want a chart with book in dimension :

use set analysis expression sum({<book = E(customerName)>} quantity)

regards

[sunny_talwar]

May be this

Dimension (Select Suppress When Value Is Null)

=Aggr(Only({<ProductTitle = e(ProductTitle), CustomerName>} ProductTitle), ProductTitle)

Expression

Sum({1} 0)

Uncheck 'Suppress Zero Values' on the presentation tab

[mrbqlik2009]

Thank you.

[sunny_talwar]

Please close the thread if you got what you were looking for.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny