P() and E() not working

[Karim_Khan]

Hi Team,

     I am clear about the concept of P() and E().But while am applying the same on my QVD its not working.

Regards,

KK

[sunny_talwar]

What exactly are you trying to get to? Without knowing your requirement it will just be a guess work.

[Karim_Khan]

I want to get the Possible Value and Excluded value in my QVD

[settu_periasamy · Accepted solution]

I think it should be like

=sum({<Year=P({<Year={'2011'}>}),Name=>}Sales)

or

if you want all possible year and exclude the name selection.. may be try like

=sum({<Year=P(Year),Name=>}Sales)

[teiswamsler]

Hi Karim

I the qvw sample u use the P() funktion wrong

this i from help:

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’

/Teis

[Anonymous]

PFA.

Syntax error was their.

[Karim_Khan]

Yes ur Right Sir

[morganaaron]

I'm not sure you do understand with P() and E() are used for. When you say you want the included or excluded values...of what? For what reason?

You can use the expressions provided by everyone here to pull any name where they have a value for year 2011, but is that what you want? Is it the name of those with sales in 2011 or is it any sales in 2011? There you're best using straight set analysis.

As sunny said, be more explicit about what you want because at the minute it doesn't make much sense..!

[Karim_Khan]

Aaron,

     I was trying to Include and Exclude the Sales for year 2011.By selecting any values from Table Box selection.

Regards,

KK