Text as a Column name in nested Applymap

[sjhussain]

Hello,

I am trying to build a key value using applymap.

What we want to do is to pass the result of one applymap which would be a column name into another applymap.  

I have tried it but it seems like it is not understanding that the result of the applymap is a column name and not text

ApplyMap('MAP_THRESHOLD1_SYNDROME',ShortName,Null()) returns "REGIONS" which is a column name and i want to use the value in the REGIONS column to be passed into the MAP_THRESHOLD1_CODE applymap. 

ShortName & '-' & applymap('MAP_THRESHOLD1_CODE',ApplyMap('MAP_THRESHOLD1_SYNDROME',ShortName,Null()),'n/a') & '-' &
ApplyMap('MAP_Threshold3_CASES',ShortName,Null()) AS KEY_CASES,

How would i do that?

[Nadi_Clarke]

Hi

Show me please you mapping-table

[Brett_Bleess · Accepted solution]

This is a duplicate post, see https://community.qlik.com/t5/QlikView-App-Development/Text-as-a-column-in-nested-applymap/m-p/16011... for full thread with solution there.

Regards,
Brett