How to display a list of customers that did not buy a particular product?

[#1]

i am trying to understand how the Customer Targetting tab works on this example:

http://us-b.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FSales%20Management%20and%20Custome...

Click on the Customer Targetting tab , and then select one of the categories in the "Did Not Purchase" section,

I am trying to figure out how the customer list is populated (ie, customers that didnt buy any bikes, or a particular product)

I am quite new to Qlikview, so any help would need to be easy to understand

[sunny_talwar]

I see what you mean, but I don't really have the option to create or modify objects in the demo app... so I am not sure how to check or confirm that the expression I gave isn't working and test for an expression which might work

[#3]

=Sum(

{<[ExcludedProductCategoryName] = e([ExcludedProductCategoryName])> +

<[ExcludedProductSubCategoryName] = e([ExcludedProductSubCategoryName])> +

<[ExcludedProductName] = e([ExcludedProductName])>

}TotalDue)

i got this partially working, but im not sure how to check for nulls in listboxes

[sunny_talwar]

What do you mean check for nulls?

[#5]

for example, if the product category selected = Bikes', and none of the others have a selection.

[sunny_talwar]

What about this

=Sum({<[ExcludedProductCategoryName] = e([ExcludedProductCategoryName]), [ExcludedProductSubCategoryName] = e([ExcludedProductSubCategoryName]), [ExcludedProductName] = e([ExcludedProductName])>}TotalDue)

[effinty2112]

Hi Paul,

I guess you're fairly new to the forum or else you'd know that Sunny and Anil are two of the most helpful and well informed Qlikview users on the planet.

Kind regards

Andrew

[#8 · Accepted solution]

yes, i am new to the forum and Qlikview.

i found something extremely simple : =sum( {1-$} TotalDue )

and this works just fine,

now i just need to understand the logic behind it.

Many thanks to all that helped out .

i will get better with this ..

[Anil_Babu_Samineni]

From help, it is self explanation

More info - Set identifiers ‒ Qlik View

[#10]

yep, if only i had found that first..:(

[Anil_Babu_Samineni]

Great, If you found solution please close this thread using flag correct answer and appropriate helpful for other. If you solve by yourself please mark yourself is correct answer.

As you said, You are new to forum read more related blogs

Qlik Community Tip: How to Get Answers to Your Post

Qlik Community Tip: Marking Replies as Correct or Helpful