Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
louise_atherton
Contributor III
Contributor III

Please help! How do I combine different tables in Qlik Sense

Hello all

I have 2 data sets which I want to combine into the one table. 

louise_atherton_0-1623328000864.png

I also only have a diluted version of Qlik sense so would need to be able to create this using an expression in the 'edit expression' section. 

 

Many thanks to all those who take the time to read and help. 

 

Louise 

8 Replies
GaryGiles
Specialist
Specialist

With [Database Registration] as your dimension, you could use the following as a measure:

=Concat(if([Database Registration]=[Checklist Registration],[Checklist Registration],''))

louise_atherton
Contributor III
Contributor III
Author

Thanks for responding.  Have tried that but still doesn't pull any values through.  so the Checklist Registration column is blank 😞

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

@GaryGiles answer should work -- if you use [Database Registration] as Dimension in the chart and his expression as Measure.  Do you have a dimension?

-Rob

louise_atherton
Contributor III
Contributor III
Author

Unfortunately it literally doesn't pull anything through at all 😞

louise_atherton_0-1623657049574.png

 

GaryGiles
Specialist
Specialist

So, in your actual data, the Database registration field is named [Risk Assessments: Additional control measures]

and Checklist Registration is named [Audits: Vehicle registration]?  Are the tables in your data model joined by any field?  What does the data model look like?

louise_atherton
Contributor III
Contributor III
Author

Yeah the data is actually stores in the risk assessment module and the checklists completed in our audits & inspections module.  Would I need our supplier developers to link the two fields together somehow in order to be able to successfully compare the 2? Both datasets are free text boxes with validation rules on to prevent spaces or special characters being used. 

GaryGiles
Specialist
Specialist

No, the tables don't need to be joined.  I was asking to see if there might be something else causing the expression to not return values.  Attached is a qvf with the tables loaded via an inline script and the expression returning the appropriate values.  

louise_atherton
Contributor III
Contributor III
Author

I can't open the attached file.  We only have a diluted version of Qlik as embedded into one of our supplier systems so we can't do anything other than write scrip using the expression editor functionality.