MAX ISSUE

[#1]

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

for example Policynum '123456' CAN HAVE MODULES 01,02,03 and 04

I am trying to pick the latest combination of policy and module

so  for above policynum I wanna see only Policynm'123456' and module '04'.

How can I do that

[sunny_talwar]

I guess, create a straight table with Policynum as your dimension and Max(module) as your expression.

[Mark_Little]

In Script

Load

     Policynum,

     MAX(Module) AS MaxModule

Resident Yourtable

Group BY Policynum;

In a chart table

Dimension Policynum

Expression Max(Module)

Mark

[#4]

In a chart table

Dimension Policynum

Expression Max(Module)

I did the above already what happens is that it works only If I have a policy num selected in the list box.  If I dont select any policy num then there is no data

[Mark_Little]

Hi,

That seems odd as it should be fine, and as long as there are no duplicates should return the required values.

Try Max(DISTINCT Module) rule out duplicates.

Mark

[#6]

Max(DISTINCT Module) same result

[#7]

Thats exactly what I did but  what happens is that it works only If I have a policy num selected in the list box.  If I dont select any policy num then there is no data

[sunny_talwar]

Would you be able to share a screenshot or a sample to show what exactly is going on?

[Mark_Little]

Can you supply some more information?

Is this information on one table?

Is the module always a numeric value? - Try wrapped in the Num() function.

If you just created a table Policyno and Module, what do you see?

Mark

[Peter_Cammaert]

Are the possible modules for a single policy listed in a string (like '01, 02, 03, 04') or are they available as separate field values?