topic Re: p() in QlikView

p()

surajap123 — Tue, 27 Jan 2015 14:07:52 GMT

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

Re: p()

maleksafa — Tue, 27 Jan 2015 14:12:50 GMT

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

Re: p()

alexandros17 — Tue, 27 Jan 2015 14:13:09 GMT

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

Re: p()

its_anandrjs — Tue, 27 Jan 2015 14:16:54 GMT

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

Re: p()

surajap123 — Tue, 27 Jan 2015 14:34:58 GMT

Thanks for the explanation!!

Re: p()

Thu, 17 Sep 2015 11:56:58 GMT

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?