Announcements
cancel
Showing results for
Did you mean:
Specialist

## 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?

1 Solution

Accepted Solutions
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
Partner - Champion III

Something like

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Specialist
Author

yes but i want that using a p() function

Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser