Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

HELP! Creating a Dimension!

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?

Tags (1)
1 Solution

Accepted Solutions

Re: HELP! Creating a Dimension!

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 Replies

Re: HELP! Creating a Dimension!

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

Not applicable

Re: HELP! Creating a Dimension!

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?

Re: HELP! Creating a Dimension!

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;

...

Not applicable

Re: HELP! Creating a Dimension!

Let me give that a go!

Not applicable

Re: HELP! Creating a Dimension!

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

Community Browser