topic Re: MAX VAL ISSUE in QlikView

MAX VAL ISSUE

Fri, 11 Dec 2015 20:26:43 GMT

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 — Fri, 11 Dec 2015 20:40:32 GMT

Hi,

Please see the attached.

maxgro — Fri, 11 Dec 2015 21:00:27 GMT

add to your script

Right Keep (Policy)

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