HELP! Creating a Dimension!

[#1]

Hello Everyone!

I need help...

I have 4 excel spreadsheets. The all contain similar data. One column is called [BC] and the 3 others are named [Sheet name $ BC].

I have a bar chart where the dimension is [BC] but it is only representing the first excel file [BC]. How can I get them to all count ack as one BC?

Side Note - These excel sheets are all alone and not joined to each other because of what I am provided most of the data on and it didn't suggest "Associations" when I loaded them.

Suggestions or thoughts on how to do this?

[sunny_talwar]

No association between them? Are you looking for one dimension or multiple dimensions here?

[#3]

Hi Sunny!

I was looking to see if I could take 4 columns of data (each from a separate spreadsheet) and create one dimension. I'm not sure why Qlik Sense didn't see the relationship. Is there a way for me to force the relationship?

[sunny_talwar · Accepted solution]

May be rename them to be called all with one name and concatenate the tables into one table?

Table1:

LOAD BC,

          ...

FROM Excel1;

Concatenate (Table1)

LOAD [Sheet name $ BC] as BC

          ...

FROM Excel2;

...

[#5]

Let me give that a go!

[#6]

I'd be lost without you Sunny! Many thanks!