topic what is the difference between p() and e() ? in QlikView

what is the difference between p() and e() ?

Tue, 09 Sep 2014 14:22:19 GMT

Hi ,

can anyone explain what is p() and e() ? use ?

Re: what is the difference between p() and e() ?

MK_QSL — Tue, 09 Sep 2014 14:25:18 GMT

P() representing the element set of possible values

sum( {$<Customer = P({1<Product={‘Shoe’}>})>} 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.

E() representing the element set of excluded values

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.

Re: what is the difference between p() and e() ?

its_anandrjs — Tue, 09 Sep 2014 14:26:23 GMT

Read the mention thread related to P and E details.

P() & E()

Re: what is the difference between p() and e() ?

JonnyPoole — Tue, 09 Sep 2014 14:35:22 GMT

*** NOTE: SEE CORRECTION BELOW IN THREAD ***

A very common usage of p() and e() is to do a filter of the global set of data in QLIK.

In that situation, p() is like a 'WHERE' clause and e() is like a 'WHERE NOT' clause.

its a simplistic situation but it helps me...

sum( {$<Customer = P({1<Product={‘Shoe’}>})>} Sales )

... this is all data WHERE product=shoe

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )

... this is all data WHERE NOT product=shoe

Re: what is the difference between p() and e() ?

MK_QSL — Tue, 09 Sep 2014 14:38:47 GMT

Hi Jonathan,

Sorry but not agree with your statements...

sum( {$<Customer = P({1<Product={‘Shoe’}>})>} Sales )

... this is all data WHERE product=shoe XXXXXXX

This is actually SUM(Sales) for Customers who bought Shoe at least once ..!!

sum( {$<Customer = E({1<Product={‘Shoe’}>})>} Sales )

... this is all data WHERE NOT product=shoe XXXXXXXX

This is actually SUM(Sales) for Customers who never bought Shoe ...

Of Cource, the above two will be affected by current selection...

let me know if I am wrong..!

Re: what is the difference between p() and e() ?

JonnyPoole — Tue, 09 Sep 2014 14:50:57 GMT

no you are absolutely right .. thanks for calling it out!

Re: what is the difference between p() and e() ?

Tue, 09 Sep 2014 15:00:41 GMT

thanks to all

Re: what is the difference between p() and e() ?

MK_QSL — Tue, 09 Sep 2014 15:09:16 GMT

Kindly close the thread by selecting appropriate answer