topic Counting customers from a particular week in QlikView https://community.qlik.com/t5/QlikView/Counting-customers-from-a-particular-week/m-p/161107#M35125 <HTML><HEAD></HEAD><BODY><P>I am having trouble showing a specific group of customers. My data is organized in the following way - each week represents a cohort. I have a calendar table with the cohort name and start day. What I want to do is count and show only the customers from the last week in a table with no dimension. I tried</P><P><I></I></P><P></P><P>=</P><P><B>count</B>({&lt;<B>Starts</B> = {<B><I>'$(="5/3/2010")'</I></B>}&gt;}<B>line_id</B>)</P><BR /><BR /> <BR /><BR /> <P>where Starts is the Start Day and line_id is the customer identifier. The code works if I use the cohort name, but I don't want to, as it will change each week. Any ideas where would be the problem?</P><P>Thank you!</P><P></P><P></P></BODY></HTML> Sat, 22 May 2010 01:42:28 GMT 2010-05-22T01:42:28Z Counting customers from a particular week https://community.qlik.com/t5/QlikView/Counting-customers-from-a-particular-week/m-p/161107#M35125 <HTML><HEAD></HEAD><BODY><P>I am having trouble showing a specific group of customers. My data is organized in the following way - each week represents a cohort. I have a calendar table with the cohort name and start day. What I want to do is count and show only the customers from the last week in a table with no dimension. I tried</P><P><I></I></P><P></P><P>=</P><P><B>count</B>({&lt;<B>Starts</B> = {<B><I>'$(="5/3/2010")'</I></B>}&gt;}<B>line_id</B>)</P><BR /><BR /> <BR /><BR /> <P>where Starts is the Start Day and line_id is the customer identifier. The code works if I use the cohort name, but I don't want to, as it will change each week. Any ideas where would be the problem?</P><P>Thank you!</P><P></P><P></P></BODY></HTML> Sat, 22 May 2010 01:42:28 GMT https://community.qlik.com/t5/QlikView/Counting-customers-from-a-particular-week/m-p/161107#M35125 2010-05-22T01:42:28Z