Regarding p() and e()

d_koti24 — Thu, 27 Aug 2015 15:09:28 GMT

Hi all,

What are the possible values and exclude values?can anyone explain with sample examples

regards,

Re: Regarding p() and e()

Gysbert_Wassenaar — Thu, 27 Aug 2015 17:20:27 GMT

Read this blog post for understanding possible and excluded values: Colors, States and State vectors

Re: Regarding p() and e()

qlikviewwizard — Sat, 29 Aug 2015 07:27:57 GMT

Hi,

Please check these threads as well. Thank you.

P() & E()

A Primer on Set Analysis

Re: Regarding p() and e()

jagan — Sat, 29 Aug 2015 09:29:34 GMT

Hi Koti,

From Qlikview help file:

Set Modifiers with Implicit Field Value Definitions

In the above examples, all field values have been explicitly defined or defined through searches. There is however 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.

P() or E() to is used to include/exclude the possible values of a field in set analysis expression. Suppose

sum( {$<Customer = P({1<Product={‘Shoe’}>} Supplier)>} Sales ) - -This returns the sales of Customers who bought shoes.

sum( {$<Customer = E({1<Product={‘Shoe’}>} Supplier)>} Sales ) - -This returns the sales of Customers who do not bought shoes.

Hope this helps you.

Regards,

Jagan.

topic Re: Regarding p() and e() in QlikView

Regarding p() and e()

Re: Regarding p() and e()

Re: Regarding p() and e()

Re: Regarding p() and e()

Set Modifiers with Implicit Field Value Definitions