topic Set Analysis - New and Active Customers in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-New-and-Active-Customers/m-p/159504#M34118 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P>I need to create one chart with one dimension (Company) with two expressions - New Customers and Active Customers.... I'm trying to use Set Analysis, with the P() and E() functions. This chart has the condition to calculate only with one month selected.</P><P>New Customers: customers that have bought in the selected month and never before<BR />Active Customers: customers that have bought at least one time in the past 6 months (selected month included).</P><P>I'm trying something like this (don't work):<BR />Count( {$&lt;nCdCustomer = P({1&lt;data = {"&lt;=$(=monthstart(max(data)))"}&gt;} nCdCustomer)&gt;} distinct nCdCustomer)</P><P>Thank you very much again.</P><P>Best Regards<BR />Julian</P><P></P></BODY></HTML> Thu, 20 May 2010 20:40:19 GMT 2010-05-20T20:40:19Z Set Analysis - New and Active Customers https://community.qlik.com/t5/QlikView/Set-Analysis-New-and-Active-Customers/m-p/159504#M34118 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P>I need to create one chart with one dimension (Company) with two expressions - New Customers and Active Customers.... I'm trying to use Set Analysis, with the P() and E() functions. This chart has the condition to calculate only with one month selected.</P><P>New Customers: customers that have bought in the selected month and never before<BR />Active Customers: customers that have bought at least one time in the past 6 months (selected month included).</P><P>I'm trying something like this (don't work):<BR />Count( {$&lt;nCdCustomer = P({1&lt;data = {"&lt;=$(=monthstart(max(data)))"}&gt;} nCdCustomer)&gt;} distinct nCdCustomer)</P><P>Thank you very much again.</P><P>Best Regards<BR />Julian</P><P></P></BODY></HTML> Thu, 20 May 2010 20:40:19 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-New-and-Active-Customers/m-p/159504#M34118 2010-05-20T20:40:19Z