topic Need help to create aggregation formula in QlikView https://community.qlik.com/t5/QlikView/Need-help-to-create-aggregation-formula/m-p/1021989#M345627 <HTML><HEAD></HEAD><BODY><P>1.I want a user to enter a date and store in a variable.</P><P>2.Then I want all the rows having date less than the entered date</P><P>3.Then for each ID I want to find max date and if max date is having status as "Open" then count the ID other wise don't count</P><P></P><P>I am attaching a excel file having three columns.</P><P></P><P>Basically I want to know as of entered date at ID level max date count all IDs if status is open for their max date</P></BODY></HTML> Thu, 31 Mar 2016 04:14:15 GMT 2016-03-31T04:14:15Z Need help to create aggregation formula https://community.qlik.com/t5/QlikView/Need-help-to-create-aggregation-formula/m-p/1021989#M345627 <HTML><HEAD></HEAD><BODY><P>1.I want a user to enter a date and store in a variable.</P><P>2.Then I want all the rows having date less than the entered date</P><P>3.Then for each ID I want to find max date and if max date is having status as "Open" then count the ID other wise don't count</P><P></P><P>I am attaching a excel file having three columns.</P><P></P><P>Basically I want to know as of entered date at ID level max date count all IDs if status is open for their max date</P></BODY></HTML> Thu, 31 Mar 2016 04:14:15 GMT https://community.qlik.com/t5/QlikView/Need-help-to-create-aggregation-formula/m-p/1021989#M345627 2016-03-31T04:14:15Z Re: Need help to create aggregation formula https://community.qlik.com/t5/QlikView/Need-help-to-create-aggregation-formula/m-p/1021990#M345628 <HTML><HEAD></HEAD><BODY><P>Create Straight Table</P><P></P><P>Dimension:</P><P>ID</P><P></P><P>Expression:</P><P>=count ({&lt;Date ={"$(=max(Date)"}, Status ={"Open"}&gt;}ID)</P></BODY></HTML> Thu, 31 Mar 2016 10:12:44 GMT https://community.qlik.com/t5/QlikView/Need-help-to-create-aggregation-formula/m-p/1021990#M345628 Kushal_Chawda 2016-03-31T10:12:44Z