Join 2 Inline Tables

[pgalvezt]

Hello,

I have this:

Filtros1:

LOAD * Inline [

Filtro1

Sales

Q

Average Price

];

Filtros2:

Left Join(Filtros1)

LOAD * Inline [

Filtro2

Sales

Q

];

I need to use the first filter in my first sheet (In my formula chart... If (Filtro1 = Sales, etc..). and I need to use the second filter in my 2nd sheet ((In my formula chart... If (Filtro2 = Sales, etc... ) ...

But when I select Sales just one of the filters change... In my second sheet nothing happens. I tried with concatenate function.

but doesn´t work. Is there a way to join these tables and use it in both sheets.

Thank you!

[sunny_talwar]

How about creating something like this:

Filtros1:

LOAD * Inline [

Select, Filtro1, Filtro2

Sales, Sales, Sales

Q, Q, Q

Average Price, Average Price,

];

Now you can make selections in Select field.

[pgalvezt]

Hi Sunny,

Works, but When I select "Sales" in my first sheet, the other field shows "Sales" (White). Is there a way when I select sales, the other sales be green too.

Is there a way to delete the empty space?

Average Price, Average Price, Delete here?

Thank you!

If there no possibility I will mark the answer as correct anyway

[sunny_talwar · Accepted solution]

You can use Trigger to select Sales for the other filtro.

For your second issue, try this:

Filtros1:

LOAD Select,

          Filtro1,

          If(Len(Trim(Filtro2)) > 0, Filtro2) as Filtro2;

LOAD * Inline [

Select, Filtro1, Filtro2

Sales, Sales, Sales

Q, Q, Q

Average Price, Average Price,

];