I have a simple question: I want to use the fields generated by qlikview. The script below illustrates what I have done. In this case, how can I make use of [Custodian Final] further in the script? What I want to do for example is combine the new field with another field by [Custodian Final]&"_"&[Trans. code].
However, I can't get StarMap2 to display. I am sure I am doing something wrong. Below is the script I am using. It is different from the example I have shown you before. In this example I can derive from the model portfolio or model portfolio code whether something is internal or external. In the end I want to combine the field [Code intern/extern] with the created fields [intern/extern 2] and [intern/extern 3].
LOAD [Model portfolio code],
[Model portfolio name],
[Model portfolio code],
applymap('Map',[Model portfolio code],'not found')&'_'&[Trans. code] as InternExtern,
applymap('Map2',[Model portfolio],'not found')&'_'&[Trans. code] as InternExtern2
&"_"&InternExtern&"_"&InternExtern2 as InternExtern3