topic Re: Text as a Column name in nested Applymap in QlikView

Text as a Column name in nested Applymap

sjhussain — Sat, 16 Nov 2024 03:02:39 GMT

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?

Re: Text as a Column name in nested Applymap

Nadi_Clarke — Mon, 15 Jul 2019 18:46:45 GMT

Show me please you mapping-table

Re: Text as a Column name in nested Applymap

Brett_Bleess — Thu, 01 Aug 2019 13:57:31 GMT

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

Regards,
Brett