4 Replies Latest reply: Jan 24, 2018 7:55 AM by Jonathan Dienst

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

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

• ###### Re: Can anyone explain me a set analysis with p() and e() functions?

Something like

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

• ###### Re: Can anyone explain me a set analysis with p() and e() functions?

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

• ###### Re: Can anyone explain me a set analysis with p() and e() functions?

yes but i want that using a p() function

• ###### Re: Can anyone explain me a set analysis with p() and e() functions?

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.