topic Re: Join 2 Inline Tables in QlikView

Join 2 Inline Tables

pgalvezt — Wed, 21 Sep 2016 15:13:25 GMT

Hello,

I have this:

Filtros1:

LOAD * Inline [

Filtro1

Sales

Average Price

];

Filtros2:

Left Join(Filtros1)

LOAD * Inline [

Filtro2

Sales

];

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!

Re: Join 2 Inline Tables

sunny_talwar — Wed, 21 Sep 2016 15:16:26 GMT

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.

Re: Join 2 Inline Tables

pgalvezt — Wed, 21 Sep 2016 15:54:13 GMT

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

Re: Join 2 Inline Tables

sunny_talwar — Wed, 21 Sep 2016 15:57:02 GMT

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,

];