Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
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
settu_periasamy
Master III
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)

View solution in original post

8 Replies
sunny_talwar

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

Karim_Khan
Creator III
Creator III
Author

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

KK
settu_periasamy
Master III
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)

View solution in original post

teiswamsler
Partner
Partner

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

balrajahlawat
Champion
Champion

PFA.

Syntax error was their.

Karim_Khan
Creator III
Creator III
Author

Yes ur Right Sir

KK
morganaaron
Specialist
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..!

Karim_Khan
Creator III
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