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: 
Karl_Hart
Creator
Creator

Chart with unrelated Dimension & Expression

All,

I have a Data Table which has been produced by concatenating two sets of data together, lets call them DataSet1 and DataSet2. Some fields are common but not all. 

I now want to create a chart that has multiple dimensions, some that are common to both data sets and some that are only found in DataSet1. The expression is looking at data from DataSet2.

I cannot get the dimensions from DataSet1 to show in the table. I've attached a very basic example. 

Is there a way of tweaking the expression to get it to show all the dimensions?

Labels (3)
4 Replies
prabir_c
Partner - Creator
Partner - Creator

Hi Karl_Hart,

Use left join instead of Concatenate

left Join(SiteOwner)

Karl_Hart
Creator
Creator
Author

Thank you for your feedback. I would have said in my original post but the attached file is just a simple example of my problem. My real data is concatenated and cannot be left joined
prabir_c
Partner - Creator
Partner - Creator

Hi Karl_Hart,

Is it mandatory to concatenate two table?

If not we can achieve this using applymap function.

Please check attached.

Hope it Helps!

Karl_Hart
Creator
Creator
Author

Thanks for the suggestion. Although your solution works for my small example, in reality I have two huge tables of data that I am concatenating together, so changing the data structure (by left join of applymap) isn't an option for me. I'm looking for a solution in the front end