What is meant by Indircet Set Analysis...?

Mon, 28 Jun 2010 09:01:46 GMT

Hi All,

Wishes from Jai.I would like to know what is meant by "Indirect set analysis" and how it perfomed?and what is the diffrence between set analysis amd indircet set analysis.Any of you have sample QVW then please share with me.

Thanks & Regards

Jai

What is meant by Indircet Set Analysis...?

spsrk_84 — Mon, 28 Jun 2010 09:20:43 GMT

Indirect Set Analysis

Set analysis was previously restricted to stating direct selections in a

field.

Starting with version 9, it is now possible to state selections in a field

based on selections in another field.

The functions p() and e() can be used to select the set of possible or

excluded values within a field.

Indirect Set Analysis

• p( ) = Possible

• e( ) = Excluded

Excluded

Possible

Customer = p({<Year={$(=max(Year)-1)}>} Customer)

Returns customers who had an association to last year.

sum(({<Year={$(=max(Year))},

Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)

Returns this year's sales for customers who had sales last year

Indirect Set Analysis

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes.

The set p({}) returns the values of CompanyName (Customer) that

purchased Baby Clothes.

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName) - p({$<CategoryName={'SportsWear'}>}

CompanyName)>} Sales)

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.

Regards,

Ajay

What is meant by Indircet Set Analysis...?

Mon, 28 Jun 2010 09:45:47 GMT

Dear Ajay,

thanks for your kind rely.I am having some querys on this.If possible please share the .qvw for more clrity.Sorry for the inconvenience.

Thanks & Regards

Jai

topic What is meant by Indircet Set Analysis...? in QlikView

What is meant by Indircet Set Analysis...?

What is meant by Indircet Set Analysis...?

What is meant by Indircet Set Analysis...?