Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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!

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