Adv. Indirect Set Analysis

Mon, 16 Sep 2013 16:16:25 GMT

Hi all, a lot of helpful QV doc here about set analysis but I still have one qst remained unanswered. Sorry if I'm missing some useful post.

This is QV demo example:

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>} CompanyName) - p({$<CategoryName={'SportsWear'}>} CompanyName)>} Sales)

Explanation: Sales for Customers who purchased Baby Clothes but not Sportswear.The first set p({}) returns CompanyName that purchased Baby Clothes.The second set p({}) returns CompanyName that Purchased SportsWear.The Unary Operator "-" between the two gives a list of Customers (CompanyName)that belong to the first but not the other set.

The qst are:

can this -p() thing be done by e()
and 2nd more important is how can I see the names of those Customers listed in straight/pivot chat and not just their sum of sales.

Or to make it more general how to get a list of Customer who didn't buy some Article or some Category?

Thank you in advance,

Milan

Re: Adv. Indirect Set Analysis

Gysbert_Wassenaar — Mon, 16 Sep 2013 16:44:52 GMT

Yes: sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>} CompanyName) * e({$<CategoryName={'SportsWear'}>} CompanyName)>} Sales)
Add Customer as a dimension to the chart/table. You can hide the Sales expression if you don't want to see the amount.

topic Re: Adv. Indirect Set Analysis in QlikView

Adv. Indirect Set Analysis

Re: Adv. Indirect Set Analysis