Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi
Show me please you mapping-table
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