topic Set Analysis...again... in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-again/m-p/241041#M91492 <HTML><HEAD></HEAD><BODY><P></P><P>Hello All!</P><P>I have a table with transactions. Each transaction have a CompanyID and a date. For a specific period I would like to count all CompanyID that also are found in previous periods. That is, I would like to count all repetitive CompanyID's per period.</P><P>I have an expression like this:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />=count({$&lt; CompanyID = {"=count({1&lt;Date={'*'}&gt;} CompanyID) &gt; 1"} &gt;}CompanyID)<BR /></PRE><BR /><BR /> <P>This expression should count all CompanyID that also could be found in on other dates. What <I>I would like</I> to count is all CompanyID that also could be found on all <B>previous</B> dates from the made selection. That is, if the selection is August 2010 I would like to count all CompanyID in August that also could be found in all dates <B>previous</B> to August 2010.</P><BR /><BR /> <P>Any suggestion how to change my expression is appreciated.</P><P>Br</P><P>Cristian</P></BODY></HTML> Tue, 03 Aug 2010 18:19:40 GMT 2010-08-03T18:19:40Z Set Analysis...again... https://community.qlik.com/t5/QlikView/Set-Analysis-again/m-p/241041#M91492 <HTML><HEAD></HEAD><BODY><P></P><P>Hello All!</P><P>I have a table with transactions. Each transaction have a CompanyID and a date. For a specific period I would like to count all CompanyID that also are found in previous periods. That is, I would like to count all repetitive CompanyID's per period.</P><P>I have an expression like this:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />=count({$&lt; CompanyID = {"=count({1&lt;Date={'*'}&gt;} CompanyID) &gt; 1"} &gt;}CompanyID)<BR /></PRE><BR /><BR /> <P>This expression should count all CompanyID that also could be found in on other dates. What <I>I would like</I> to count is all CompanyID that also could be found on all <B>previous</B> dates from the made selection. That is, if the selection is August 2010 I would like to count all CompanyID in August that also could be found in all dates <B>previous</B> to August 2010.</P><BR /><BR /> <P>Any suggestion how to change my expression is appreciated.</P><P>Br</P><P>Cristian</P></BODY></HTML> Tue, 03 Aug 2010 18:19:40 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-again/m-p/241041#M91492 2010-08-03T18:19:40Z Set Analysis...again... https://community.qlik.com/t5/QlikView/Set-Analysis-again/m-p/241042#M91493 <HTML><HEAD></HEAD><BODY><P>It should be something like</P><P></P><P></P><PRE><BR />=count({$&lt; CompanyID = {"=count({1&lt;Date={"&lt;$(=date(max(date),'mm/dd/yyyy')"}&gt;} CompanyID) &gt; 1"} &gt;}CompanyID)&lt;div&gt;&lt;/div&gt;</PRE><BR /><BR /></BODY></HTML> Fri, 06 Aug 2010 21:37:09 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-again/m-p/241042#M91493 danielrozental 2010-08-06T21:37:09Z