Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

apply map error

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

script.pngexcel.pngerror.png

1 Solution

Accepted Solutions
t_chetirbok
Creator III
Creator III

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

;

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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
Creator III
Creator III

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
Not applicable
Author

Thank you soooooooo much

Anonymous
Not applicable
Author

Thanks for your help