Problems with merging fields in QLIK SENCE

[Midchen]

I have three tables, all with MONTH fields.

I want to add a ‘year’ to the above two tables to facilitate filtering.
But only 'action' can be combined with 'year-month', not 'KPI'.

It's on a list, but they're not connected.
I can't find the reason, please help me.

Thank you in advance

[justISO · Accepted solution]

Hi, I guess in 'KPI' table your 'Month' field is treated as text and in 'action' as num (alignment is different). I would suggest to convert and equalize all these fields to date first and try merging again.