topic Re: How can I count rows with column values selected from a another list in QlikView https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436344#M697848 <HTML><HEAD></HEAD><BODY><P>Could you please provide any sample data? how exactly your source tables look like???</P></BODY></HTML> Thu, 14 Feb 2013 14:39:45 GMT manideep78 2013-02-14T14:39:45Z How can I count rows with column values selected from a another list https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436342#M697846 <HTML><HEAD></HEAD><BODY><P>I have created a list containing years and another containing months. Excel containing three different date columns.</P><P>When I select a year or a month (or both) from a list report has to count number rows found for those 3 columns.</P><P></P><P>Data (DD.MM.YYYY):</P><P>Id&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Column1&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Column2&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Column3</P><P>---------------------------------------------------------------------------</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02.02.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03.01.2013</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01.01.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01.02.2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03.02.2013</P><P></P><P>Situation1:</P><P>When I select a year (2013) &gt; report shows value 2 for all of those fields.</P><P>Situation2:</P><P>When I select a month (02=february) &gt; report shows value 2 only for col2 and 1 for col3 fields.</P><P>Situation3:</P><P>When I select month (01=january) and year (2013) &gt; report shows value 2 for col1 and 1 for col3 fields.</P></BODY></HTML> Thu, 14 Feb 2013 13:21:13 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436342#M697846 2013-02-14T13:21:13Z Re: How can I count rows with column values selected from a another list https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436343#M697847 <HTML><HEAD></HEAD><BODY><P>Cuold you provide the source tables?</P></BODY></HTML> Thu, 14 Feb 2013 13:40:07 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436343#M697847 alexandros17 2013-02-14T13:40:07Z Re: How can I count rows with column values selected from a another list https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436344#M697848 <HTML><HEAD></HEAD><BODY><P>Could you please provide any sample data? how exactly your source tables look like???</P></BODY></HTML> Thu, 14 Feb 2013 14:39:45 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436344#M697848 manideep78 2013-02-14T14:39:45Z Re: How can I count rows with column values selected from a another list https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436345#M697849 <HTML><HEAD></HEAD><BODY><P>Excel document in attachments</P></BODY></HTML> Thu, 14 Feb 2013 14:49:46 GMT https://community.qlik.com/t5/QlikView/How-can-I-count-rows-with-column-values-selected-from-a-another/m-p/436345#M697849 2013-02-14T14:49:46Z