topic apply map error in QlikView

apply map error

Anonymous — Tue, 19 Jan 2016 05:18:38 GMT

Hi everyone

I write script using apply map, but qlik show me the error sign . i completely confused

i loading script, excel and error message here

hope you can guide me

Anonymous — Tue, 19 Jan 2016 08:05:50 GMT

maybe the error is while the statements are in same load

you create your field and retrieve it in same load

use preload to define your field JRealMonth

Load *,

... as JRealMonth;

load

applymap.....

t_chetirbok — Tue, 19 Jan 2016 08:27:41 GMT

Hello!

try this

load

applymap('Map',Field) as A

, applymap('Map2',Field) as B

, applymap('Map3',Field) as C

, applymap('Map4',Field) as D

, applymap('Map5',Field) as E

applymap('Map3',Field) &'/'& applymap('Map4',Field) &'/'& applymap('Map5',Field) as JRealMonth

;

Anonymous — Tue, 19 Jan 2016 08:35:47 GMT

Thank you soooooooo much

Anonymous — Tue, 19 Jan 2016 08:36:41 GMT

Thanks for your help