topic Re: Difference between P() and E() function? in QlikView

Difference between P() and E() function?

Thu, 07 Aug 2014 15:14:29 GMT

Please any body help me what is difference between P&E function with example.

marcus_malinow — Thu, 07 Aug 2014 15:19:45 GMT

These are not functions, rather they are indirect set modifiers.

You may want to show total sales for customers who bought product A.

Sum({$<Customer=P({1<Product={'A'})>} Sales)

Or Sales for customers who haven't bought product A

Sum({$<Customer=E({1<Product={'A'})>} Sales)

marcus_malinow — Thu, 07 Aug 2014 15:22:38 GMT

Just to clarify, P means Possible, and E means Excluded

maxgro — Thu, 07 Aug 2014 15:22:46 GMT

some answers for the same question

SelvaKumar — Thu, 28 Mar 2019 12:47:54 GMT

So,

Sum({$<Customer=E({1<Product={'A'})>} Sales)

equals to

Sum({$<Customer-=P({1<Product={'A'})>} Sales) ?

Kindly educate me on this whether both are same or otherwise.

Thanks,

Selva