# Qlik Sense App Development

Contributor II

## use two colour inline tables

Hi

I have two colour inline tables - is there a way of using two colour inline tables please?

I have

ColourDT:

DT, R,G,B

'A', 204, 102, 119

'B', 102, 153, 204

'C', 51, 0, 255

AND

ColourDP:

Dept, R,G,B

'Catering', 204, 102, 119

'HomeWare', 102, 153, 204

'Kids', 51, 0, 255

I keep getting a loop, or if I join one of the tables, one of the colour tables, e.g ColourDP , all column Dept colours turns black, where column DT works

1 Solution

Accepted Solutions
MVP

## Re: use two colour inline tables

Try this:

ColourDT:

DT, R1,G1,B1

'A', 204, 102, 119

'B', 102, 153, 204

'C', 51, 0, 255

];

ColourDP:

Dept, R2, G2, B2

'Catering', 204, 102, 119

'HomeWare', 102, 153, 204

'Kids', 51, 0, 255

];

4 Replies
MVP

## Re: use two colour inline tables

Try this:

ColourDT:

DT, R1,G1,B1

'A', 204, 102, 119

'B', 102, 153, 204

'C', 51, 0, 255

];

ColourDP:

Dept, R2, G2, B2

'Catering', 204, 102, 119

'HomeWare', 102, 153, 204

'Kids', 51, 0, 255

];

MVP

## Re: use two colour inline tables

I am not sure how you intend o use this information, but joining tables is essentially enriching or adding to the information on each row - for example joining something to table 1 on the field DT to provide additional information about DT.

I assume that this is not you intention - each row of ColourDP stands distinct from the rows in ColourDT. In this case, do noy join - rather concatenate the rows into a single colour table. Force the concatenation using the Concatenate key word.

Contributor II

## Re: use two colour inline tables

Your just Awesome, thank you x

MVP

## Re: use two colour inline tables

Awesome, I am glad I was able to help