Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

joining tables

Hii,

I have question on two tables. I have one table that has budget and actual sales data for year with some dimensions and i have another table in different file which has forecast for the present year. now I have to create a dashboard using these two files.

When I think of joining these two tables then I think there will be an issue because second table has a few dimensions but not all so it will give me null values. ANY THOUGHTS ON IT???

2 Replies
Clever_Anjos
Employee
Employee

Usually I concatenate them

krishnacbe
Partner - Specialist III
Partner - Specialist III

Try to create Concatenate Key/Column and join.