Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Midchen
Contributor II
Contributor II

Problems with merging fields in QLIK SENCE

I have three tables, all with MONTH fields.

Midchen_0-1652853043858.png

Midchen_2-1652853140381.png

Midchen_6-1652853398477.png

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'.

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

Thank you in advance

 



 

 

Labels (1)
1 Solution

Accepted Solutions
justISO
Specialist
Specialist

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.

View solution in original post

1 Reply
justISO
Specialist
Specialist

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.