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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.