Hello:
I'm transferring an existing report to Qlik Sense. The current SQL Server query has multiple UPDATE statements with the following being the most complex, I'm stumped! I need to figure out how to convert the logic below into a language Qlik Sense can interpret. Thanks in advance for any assistance.
UPDATE c
set c.M_Pay_Acc = p.M_Pay_Acc
FROM #c_sum c
LEFT JOIN (SELECT c.Mem_ID, c.Row_ID, c.D_Name, c.M_Pay,
ISNULL(SUM(p.Manufacturer_Pay ), 0) + c.M_Pay AS M_Pay_Acc
FROM
#c_sum c LEFT JOIN
#c_sum p
ON c.Mem_ID = p.Mem_ID AND
c.D_Name = p.D_Name AND
c.Row_ID > p.Row_ID
GROUP BY
c.Mem_ID,
c.Row_ID,
c.M_Pay,
c.D_Name
) p
ON c.Mem_ID = p.Mem_ID AND c.row_id = p.row_id AND c.D_Name = p.D_Name
