Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between P() and E() function?

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

4 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

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
Partner - Specialist III
Partner - Specialist III

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

maxgro
MVP
MVP

SelvaKumar
Contributor
Contributor

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