topic Re: MAX ISSUE in QlikView

MAX ISSUE

Fri, 11 Dec 2015 13:23:35 GMT

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

Re: MAX ISSUE

sunny_talwar — Fri, 11 Dec 2015 13:26:06 GMT

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

Re: MAX ISSUE

Mark_Little — Fri, 11 Dec 2015 13:27:15 GMT

In Script

Load

Policynum,

MAX(Module) AS MaxModule

Resident Yourtable

Group BY Policynum;

In a chart table

Dimension Policynum

Expression Max(Module)

Mark

Re: MAX ISSUE

Fri, 11 Dec 2015 13:31:32 GMT

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

Re: MAX ISSUE

Mark_Little — Fri, 11 Dec 2015 13:38:00 GMT

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

Re: MAX ISSUE

Fri, 11 Dec 2015 13:51:01 GMT

Max(DISTINCT Module) same result

Re: MAX ISSUE

Fri, 11 Dec 2015 13:52:05 GMT

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

Re: MAX ISSUE

sunny_talwar — Fri, 11 Dec 2015 13:53:04 GMT

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

Re: MAX ISSUE

Mark_Little — Fri, 11 Dec 2015 13:54:55 GMT

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

Re: MAX ISSUE

Peter_Cammaert — Fri, 11 Dec 2015 14:14:16 GMT

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?

Re: MAX ISSUE

Fri, 11 Dec 2015 14:17:25 GMT

They are available in a string and not as seperate field values

Re: MAX ISSUE

Mark_Little — Fri, 11 Dec 2015 14:22:46 GMT

Hi,

That explains the problems.

Will need to brake it down down

maybe something like

SUBFIELD(Module,',', LEN(KEEPCHAR(Module,','))

Mark

Re: MAX ISSUE

Fri, 11 Dec 2015 14:23:13 GMT

Do u have an email I can email you the screen shot cuz cant attach on reply screen

Re: MAX ISSUE

Fri, 11 Dec 2015 14:27:40 GMT

What do u mean break down?

Re: MAX ISSUE

hemhund2016 — Fri, 11 Dec 2015 14:28:15 GMT

Hi Rehan,

If they are in string, then use it as below.

Assuming Module is as '01, 02, 03, 04'

Dimension: Policynum

Expression : SubField( Module,',',-1)

Thanks,

Hemanth.

Re: MAX ISSUE

nico_ilog — Fri, 11 Dec 2015 14:28:52 GMT

What does the source data look like?

Re: MAX ISSUE

Fri, 11 Dec 2015 14:40:44 GMT

Re: MAX ISSUE

Fri, 11 Dec 2015 15:49:20 GMT

Did you get a chance to look at the screen shots I sent you

Re: MAX ISSUE

sunny_talwar — Fri, 11 Dec 2015 15:50:37 GMT

Try this:

Max(TOTAL <Policynum> module)

Re: MAX ISSUE

Fri, 11 Dec 2015 16:11:09 GMT

TRy this in Expression?