Please, someone can help me with some expressions?... - Qlik Community

Mattia · ‎2019-11-14

Hi guys,

attached is a sample data file with, in the script, inline tables and 3 output i want to see as single new fields.

Please, i need your help because i don't know how to solve this problem (if you want, you can see also the table viewer).

Which function can i use? Left Join? ApplyMap (single or double)?

Thanks for the attention.

Mattia

Brett_Bleess · ‎2019-11-19

Mattia, believe I have give you the following previously, but doing so again just in case:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Hopefully those will help you move things forward.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Mattia · ‎2019-11-19

Thx Brett.

Mattia

Please, someone can help me with some expressions? Left Join(), ApplyMap()?

Script