Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

p()

Hi Experts,

Please explan me, what we are telling in the below piece of syntax??

productID = P({$}productID)

complete expression->

sum{1<productID = P({$}productID),year={2014}>}sales)

Thanks!

Suraj

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

sum{1<productID = P({$}productID),year={2014}>}sales)

sum of all the sales where productId is among all the (P)ossible values for the 2014

View solution in original post

5 Replies
maleksafa
Specialist
Specialist

P() means possible, in your expression, you are saying to take all the possible productID and year = 2014, i think you can replace the expression sum{1<productID = P({$}productID),year={2014}>}sales) to sum({<year={2014}>}sales).

alexandros17
Partner - Champion III
Partner - Champion III

sum{1<productID = P({$}productID),year={2014}>}sales)

sum of all the sales where productId is among all the (P)ossible values for the 2014

its_anandrjs

Hi,

Here in the expression P() means Possible and by expression sum{1<productID = P({$}productID),year={2014}>}sales) you get all possible rows of productID in the year 2014 and sum the sales value.

Regards

Anand

surajap123
Creator II
Creator II
Author

Thanks for the explanation!!

Not applicable

What about the 1 in the above expression sum{1<productID = P({$}productID),year={2014}>}sales)

Does it add anything to the expression, removing it would it not be the same?