topic Re: Max functin not working with applymap in QlikView

Max functin not working with applymap

Wed, 03 Jun 2015 14:08:25 GMT

HI All,

I have below sample code .But the max is not working with the applymap.Getting an error in script execution.

Regiongrouping:

mapping load

Region,

(max(orderdate))

FROM

(biff, embedded labels)

group by Region;

OderData:

LOAD Region,

orderdate,

applyMap ('Regiongrouping', Region) as [Max oderdate],

value,

comment

FROM

(biff, embedded labels);

Why is this so?

Re: Max functin not working with applymap

sunny_talwar — Wed, 03 Jun 2015 15:27:50 GMT

Can you attach your Test.xls file for testing out your code?

Best,

Sunny

Re: Max functin not working with applymap

anbu1984 — Wed, 03 Jun 2015 15:38:21 GMT

What is the error message?

Re: Max functin not working with applymap

anbu1984 — Wed, 03 Jun 2015 15:42:02 GMT

Instead of mapping load, you can use Left join like below

OderData:

LOAD Region,

orderdate,

value,

comment

FROM

(biff, embedded labels);

Left Join(OderData)

Load Region,max(orderdate) As [Max oderdate] Resident OderData Group by Region;

Re: Max functin not working with applymap

Gabriel — Wed, 03 Jun 2015 15:42:18 GMT

Hi,

Why don't you remove the bracket from behind Max, See below

Regiongrouping:

mapping load

Region,

max(orderdate)

FROM

(biff, embedded labels)

group by Region;

OderData:

LOAD Region,

orderdate,

applyMap ('Regiongrouping', Region) as [Max oderdate],

value,

comment

FROM

(biff, embedded labels);

Re: Max functin not working with applymap

maxgro — Wed, 03 Jun 2015 22:10:22 GMT

your code works on my QlikView and with some test data (test.xls)

could you post your excel and the error?

Re: Max functin not working with applymap

stevedark — Tue, 30 Jun 2015 09:55:25 GMT

I would ensure you have a field name on the Max in the ApplyMap. It's strange that it's inconsistent if this falls over or not, but I would certainly add it for completeness:

(max(orderdate)) as OD,

As Gabsus04 states the brackets are superflous, but will not cause an issue.

The name of the field in the ApplyMap is not used anywhere - but it is probably better to have it.

Steve