topic Problem transforming group by script in QV expression in QlikView https://community.qlik.com/t5/QlikView/Problem-transforming-group-by-script-in-QV-expression/m-p/368907#M576634 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I have a problem with the following SQL code...</P><P>I must transform it into the expression language, and I don't know how this can be done...</P><P></P><P>Please help me with this.</P><P></P><P>select count(distinct a.claimid)</P><P>FROM Dauna a INNER JOIN</P><P>(select ClaimId, Max(ReportingDate) ReportingDate</P><P>FROM Dauna</P><P>WHERE ReportingDate&lt;= '20111231' GROUP BY ClaimId) b ON a.ClaimId = b.ClaimId AND a.ReportingDate= b.ReportingDate</P><P>WHERE a.RezervaRamasa != 0 <SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Thu, 26 Apr 2012 07:40:45 GMT 2012-04-26T07:40:45Z Problem transforming group by script in QV expression https://community.qlik.com/t5/QlikView/Problem-transforming-group-by-script-in-QV-expression/m-p/368907#M576634 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I have a problem with the following SQL code...</P><P>I must transform it into the expression language, and I don't know how this can be done...</P><P></P><P>Please help me with this.</P><P></P><P>select count(distinct a.claimid)</P><P>FROM Dauna a INNER JOIN</P><P>(select ClaimId, Max(ReportingDate) ReportingDate</P><P>FROM Dauna</P><P>WHERE ReportingDate&lt;= '20111231' GROUP BY ClaimId) b ON a.ClaimId = b.ClaimId AND a.ReportingDate= b.ReportingDate</P><P>WHERE a.RezervaRamasa != 0 <SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Thu, 26 Apr 2012 07:40:45 GMT https://community.qlik.com/t5/QlikView/Problem-transforming-group-by-script-in-QV-expression/m-p/368907#M576634 2012-04-26T07:40:45Z