topic Re: Can anyone explain me a set analysis with p() and e() functions? in QlikView https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6461#M607221 <HTML><HEAD></HEAD><BODY><P>Hi Arvind,</P><P></P><P>The better place to ask this question is under "New to Qlik Sense".</P><P></P><P>Sum({&lt;Customers = p({&lt;Year = {"2013"},Product = {"XYZ"}&gt;})&gt;}Sales)</P><P></P><P>All you have to do is create a table with Customer as dimension and above expression.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 24 Jan 2018 12:52:54 GMT kaushiknsolanki 2018-01-24T12:52:54Z Can anyone explain me a set analysis with p() and e() functions? https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6459#M607219 <HTML><HEAD></HEAD><BODY><P>how to find the total sales of the customers who had purchased a product='xyz' inh year 2013?</P></BODY></HTML> Wed, 24 Jan 2018 12:47:55 GMT https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6459#M607219 arvind1494 2018-01-24T12:47:55Z Re: Can anyone explain me a set analysis with p() and e() functions? https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6460#M607220 <HTML><HEAD></HEAD><BODY><P>Something like</P><P></P><P><EM>Sum({&lt;Customers = P({&lt;Product = {'xyz'}, <SPAN style="font-size: 13.3333px;">Year = {2013}</SPAN>&gt;} Customers)&gt;} Sales)</EM></P></BODY></HTML> Wed, 24 Jan 2018 12:52:30 GMT https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6460#M607220 jonathandienst 2018-01-24T12:52:30Z Re: Can anyone explain me a set analysis with p() and e() functions? https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6461#M607221 <HTML><HEAD></HEAD><BODY><P>Hi Arvind,</P><P></P><P>The better place to ask this question is under "New to Qlik Sense".</P><P></P><P>Sum({&lt;Customers = p({&lt;Year = {"2013"},Product = {"XYZ"}&gt;})&gt;}Sales)</P><P></P><P>All you have to do is create a table with Customer as dimension and above expression.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 24 Jan 2018 12:52:54 GMT https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6461#M607221 kaushiknsolanki 2018-01-24T12:52:54Z Re: Can anyone explain me a set analysis with p() and e() functions? https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6462#M607222 <HTML><HEAD></HEAD><BODY><P>yes but i want that using a p() function</P></BODY></HTML> Wed, 24 Jan 2018 12:55:21 GMT https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6462#M607222 arvind1494 2018-01-24T12:55:21Z Re: Can anyone explain me a set analysis with p() and e() functions? https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6463#M607223 <HTML><HEAD></HEAD><BODY><P>The P() expression will return <EM style="text-decoration: underline;">all</EM> 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.</P></BODY></HTML> Wed, 24 Jan 2018 12:55:49 GMT https://community.qlik.com/t5/QlikView/Can-anyone-explain-me-a-set-analysis-with-p-and-e-functions/m-p/6463#M607223 jonathandienst 2018-01-24T12:55:49Z