topic Getting matching counts in different months in QlikView https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580747#M1116261 <HTML><HEAD></HEAD><BODY><P>I have set of data for different months. I would like to see matching records for next month from previous months.</P><P></P><P>Jan, Feb, March, April</P><P></P><P>I want to see what is matching in feb for january counts, what is matching march for feb conunts</P><P>basically having inner join between different months</P><P></P><P>say january has 100 counts and february has 120 counts but february has matching count of 80. I would like to diplay 80 in a different column.</P></BODY></HTML> Thu, 27 Feb 2014 15:51:43 GMT 2014-02-27T15:51:43Z Getting matching counts in different months https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580747#M1116261 <HTML><HEAD></HEAD><BODY><P>I have set of data for different months. I would like to see matching records for next month from previous months.</P><P></P><P>Jan, Feb, March, April</P><P></P><P>I want to see what is matching in feb for january counts, what is matching march for feb conunts</P><P>basically having inner join between different months</P><P></P><P>say january has 100 counts and february has 120 counts but february has matching count of 80. I would like to diplay 80 in a different column.</P></BODY></HTML> Thu, 27 Feb 2014 15:51:43 GMT https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580747#M1116261 2014-02-27T15:51:43Z Re: Getting matching counts in different months https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580748#M1116263 <HTML><HEAD></HEAD><BODY><P>Possible to attach a dummy file with some data?</P></BODY></HTML> Thu, 27 Feb 2014 16:32:53 GMT https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580748#M1116263 2014-02-27T16:32:53Z Re: Getting matching counts in different months https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580749#M1116264 <HTML><HEAD></HEAD><BODY><P>Its like month 1 will have 2,429000 records but month 2 will have 2 million matching records probably out of 3 million&nbsp; so we need to calculate matching records in next month numbers .</P><P><BR /> </P></BODY></HTML> Thu, 27 Feb 2014 19:18:44 GMT https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580749#M1116264 2014-02-27T19:18:44Z Re: Re: Getting matching counts in different months https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580750#M1116265 <HTML><HEAD></HEAD><BODY><P>Finally got it working. I created a flag called Flag which will compare data with previous month and see how many Item# match and display the sum in it.</P><P>Check out the attached and see if it helps.</P><P></P><P>Thanks</P><P>AJ</P></BODY></HTML> Thu, 27 Feb 2014 19:58:29 GMT https://community.qlik.com/t5/QlikView/Getting-matching-counts-in-different-months/m-p/580750#M1116265 2014-02-27T19:58:29Z