cancel
Showing results for
Did you mean:
Creator III

## P() and E() not working

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

KK
1 Solution

Accepted Solutions
Master III

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)

8 Replies
MVP

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

Creator III
Author

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

KK
Master III

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)

Partner - Creator III

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
Not applicable

PFA.

Syntax error was their.

Creator III
Author

Yes ur Right Sir

KK
Specialist

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..!

Creator III
Author

Aaron,

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

Regards,

KK

KK
Community Browser