Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
May be rename them to be called all with one name and concatenate the tables into one table?
LOAD [Sheet name $ BC] as BC
No association between them? Are you looking for one dimension or multiple dimensions here?
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?
Let me give that a go!
I'd be lost without you Sunny! Many thanks!