MAX VAL ISSUE

[#1]

I have a data which includes Policynum and Module. When the policy renewes it is assigned a new mod .

In the attached sample  Policynum '1701655 '  have 10 modules.  I wanna the data set to always come back with only the latest module entries.

In the attached sample I would like to see only one row

PSL 1701655 10 330

Attached please find the Sample QVW and QVD

[sinanozdemir · Accepted solution]

Hi,

Please see the attached.

[maxgro]

add to your script

Right Keep (Policy)

load POLICY0NUM_CONSOLIDATED, MaxString(MODULE) as MODULE Resident Policy Group by POLICY0NUM_CONSOLIDATED;