Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

benefits of Indirect Set Analysis

hi,

Can anyone list out the benefits and advantages of Indirect Set Analysis over Set analysis.

Thanks and Regards,

Smitha

5 Replies
Master II
Master II

Indirect set analysis is the one that deals with Possible/Excluded values P()/E(). From help :

There is an additional way to define a set of field values by the use of a nested set definition.

In such cases, the element functions P() and E() must be used, representing the element set of possible values and the excluded values of a field, respectively. Inside the brackets, it is possible to specify one set expression and one field, e.g. P({1} Customer). These functions cannot be used in other expressions:

Examples:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )
returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.

sum( {$<Customer = P({1<Product={‘Shoe’}>})>} Sales )
same as above. If the field in the element function is omitted, the function will return the possible values of the field specified in the outer assignment.

sum( {$<Customer = P({1<Product={‘Shoe’}>} Supplier)>} Sales )
returns the sales for current selection, but only those customers that ever have supplied the product ‘Shoe’. The element function P( ) here returns a list of possible suppliers; those that are implied by the selection ‘Shoe’ in the field Product. The list of suppliers is then used as a selection in the field Customer.

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )
returns the sales for current selection, but only those customers that never bought the product ‘Shoe’. The element function E( ) here returns the list of excluded customers; those that are excluded by the selection ‘Shoe’ in the field Product.

Not applicable

Hi Smith

check this link will be helpful to You.

Indirect Set analysis

regards

Mahesh T

Not applicable

hi,

Thanks for the content on Indirect Set Analysis,but i need brief advantages and benefits of indirect set analysis over set analysis. I browsed a lot to get the content on it, but failed to get the content on it.I need to prepare a document on benefits and advantages of indirect set analysis over set analysis.

Regards,

Smitha

Not applicable

hi,

The link which u are mentioning, query was posted by me itself.

I need brief advantages and benefits of indirect set analysis over set analysis. I browsed a lot to get the content on it, but failed to get it.I used to get the information on Indirect set analysis.

I need to prepare a document on benefits and advantages of indirect set analysis over set analysis.

Regards,

Smitha

Creator
Creator

Useful Thanks