Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-04-26 03:40 AM

Problem transforming group by script in QV expression

Hello everyone,

I have a problem with the following SQL code...

I must transform it into the expression language, and I don't know how this can be done...

Please help me with this.

select count(distinct a.claimid)

FROM Dauna a INNER JOIN

(select ClaimId, Max(ReportingDate) ReportingDate

FROM Dauna

WHERE ReportingDate<= '20111231' GROUP BY ClaimId) b ON a.ClaimId = b.ClaimId AND a.ReportingDate= b.ReportingDate

WHERE a.RezervaRamasa != 0

355 Views
0 Likes
0 Replies