topic Re: ApplyMap Question in QlikView

ApplyMap Question

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

please let me know the error in below applymap

TableName:

LOAD

F1,

F2,

RangeSum(F2, Peek('CumSum')) AS CumSum;

E: MAPPING LOAD * INLINE [

F1, F2

a, 100

b, 200

c, 300

d, 400

];

load ApplyMap('E',F2) AS Y

INLINE

[F2,F5

100,2

400,5];

Re: ApplyMap Question

sunny_talwar — Thu, 11 May 2017 15:52:39 GMT

Where is table E you are applymapping from?

load ApplyMap('E',F2) AS Y

INLINE

[F2,F5

100,2

400,5];

Re: ApplyMap Question

shiveshsingh — Thu, 11 May 2017 15:54:38 GMT

here it is..

E: MAPPING LOAD * INLINE [

F1, F2

a, 100

b, 200

c, 300

d, 400

];

Re: ApplyMap Question

sunny_talwar — Thu, 11 May 2017 15:59:22 GMT

I see it now... it was hidden under your TableName table.... you are using E for Mapping and as a preceding load for TableName? You cannot do that....

Also, you need to have the F2 field before F1 for mapping to work properly

Re: ApplyMap Question

sunny_talwar — Thu, 11 May 2017 16:00:47 GMT

May be this is what you need

MAPPING

LOAD * INLINE [

F1, F1

100, a

200, b

300, c

400, d

];

TableName:

LOAD

F1,

F2,

RangeSum(F2, Peek('CumSum')) AS CumSum;

LOAD * INLINE [

F1, F2

a, 100

b, 200

c, 300

d, 400

];

LOAD ApplyMap('E',F2) as Y

INLINE

[F2,F5

100,2

400,5];

Re: ApplyMap Question

shiveshsingh — Thu, 11 May 2017 16:10:39 GMT

done..thnks