Help me to understand P() and E() functions in Qlikview



I have gone through your blog on set analysis , can you please explain me on the indirect function of P() and E() as I could not follow the function of P and E



Let’s understand it using example:-

I have created a sales dashboard and there is a tab for front line managers, here I want to show chart containing information about the total sales for managers who have done sales in last year also . In this case, we would require list of names or ECODEs of managers those have done sales in last year. Here Function P() helps.

P( ) = Possible
E( ) = Excluded

FM = p({<Year={$(=max(Year)-1)}>} FM)

Returns sales of managers who had sales last year.

Similarly, we can exclude managers who had sales last year using function E().

Hope this helps!