Discussion Board for collaboration on QlikView Scripting.
I have a problem with mappig/applymap. Hope somebody can help me.
I have tried to achieve it in two ways:#1
Key AS Key1,
[Table2.CHILD ID] AS [Table2.CHILD ID1],
[Table2.CHILD ID] AS [Table2.CHILD Name1],
Group by Key;
map [Table2.CHILD Name1] using MapNames;
ApplyMap('MapNames',[Table2.CHILD ID],'[None]') AS [Table2.CHILD Name1],
Go to Solution.
In #1 you need to have the "map [Table2.CHILD Name1] using MapNames;" before you load the field.
In #2 you need to include [Table2.CHILD ID] in the Group By.
Please explain what are you trying to do or upload a sample document with some data and the expected output
Byron Van Wyk
QlikVieW & Other Ramblings
Try without the GROUP BY
It seems correct
#2 is working perfect! thanks!
I'll retry #1 and update this post if succeed, at first I got script error
edit: both advices working perfrect. thanks again!