Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is P and E in terms of SET analysis

Hi Friends,

Some can explain with an example what is mean for P and E in the SET expression.

Appreciated in Advance

2 Replies
Not applicable
Author

Hi qlik learner,

The element functions P() and E() 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. 

Thanks,

Prakash

Not applicable
Author

Hi,

I recommend you to refer QlikView 11 for Developers - QlikView Book ,

You can take QlikView desktop's help also just press F1 in QV

Thanks,

Prakash