topic Re: P() and E() not working in QlikView

P() and E() not working

Karim_Khan — Wed, 04 Nov 2015 11:28:01 GMT

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,

Re: P() and E() not working

sunny_talwar — Wed, 04 Nov 2015 11:31:35 GMT

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

Re: P() and E() not working

Karim_Khan — Wed, 04 Nov 2015 11:33:17 GMT

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

Re: P() and E() not working

settu_periasamy — Wed, 04 Nov 2015 11:36:09 GMT

I think it should be like

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

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

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

Re: P() and E() not working

teiswamsler — Wed, 04 Nov 2015 11:36:17 GMT

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

Re: P() and E() not working

Anonymous — Wed, 04 Nov 2015 11:38:03 GMT

PFA.

Syntax error was their.

Re: P() and E() not working

Karim_Khan — Wed, 04 Nov 2015 11:41:19 GMT

Yes ur Right Sir

Re: P() and E() not working

morganaaron — Wed, 04 Nov 2015 11:41:38 GMT

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

Re: P() and E() not working

Karim_Khan — Wed, 04 Nov 2015 11:43:50 GMT

Aaron,

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

Regards,