Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Karl_Hart
Contributor

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
Partner
Partner

Re: Chart with unrelated Dimension & Expression

Hi Karl_Hart,

Use left join instead of Concatenate

left Join(SiteOwner)

Karl_Hart
Contributor

Re: Chart with unrelated Dimension

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
Partner
Partner

Re: Chart with unrelated Dimension

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!

Highlighted
Karl_Hart
Contributor

Re: Chart with unrelated Dimension

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