Can anyone explain me a set analysis with p() and e() functions?

[arvind1494]

how to find the total sales of the customers who had purchased a product='xyz' inh year 2013?

[jonathandienst]

Something like

Sum({<Customers = P({<Product = {'xyz'}, Year = {2013}>} Customers)>} Sales)

[kaushiknsolanki]

Hi Arvind,

The better place to ask this question is under "New to Qlik Sense".

Sum({<Customers = p({<Year = {"2013"},Product = {"XYZ"}>})>}Sales)

All you have to do is create a table with Customer as dimension and above expression.

Regards,

Kaushik Solanki

[arvind1494]

yes but i want that using a p() function

[jonathandienst · Accepted solution]

The P() expression will return all sales for customers with any sale that meets the criteria. The simple set expression returns sales transactions that meet the criteria. Not quite the same thing.