topic Re: Table join issue in QlikView

Table join issue

Mon, 17 Nov 2014 06:06:23 GMT

Dear friends,

I have three tables call table_A,table_B and table_C.

when i create a dashboard linked with this three tables (from ItemID) i can see all the data in this all three tables.I want to show the data only get from table_C.

Ex. only need to show the data of item 1 to 10 in any ware on the dashboard.

Re: Table join issue

sushil353 — Mon, 17 Nov 2014 06:10:28 GMT

Hi,

for this you can simply make use of join..

TableC:

Load * from sourceC;

left join(TableC)

load * from sourceB;

left join(TableC)

load * from sourceA;

HTH
Sushil

Re: Table join issue

sujeetsingh — Mon, 17 Nov 2014 06:10:32 GMT

Load table C

;;;

;;From:

Left join Table A

'''

'''' from ;

left join table B;

Re: Table join issue

anbu1984 — Mon, 17 Nov 2014 06:10:45 GMT

Table_C:

Load * From Table_C;

Left Join(Table_C)

Load * From Table_B;

Left Join(Table_C)

Load * From Table_A;

Re: Table join issue

jonathandienst — Mon, 17 Nov 2014 06:16:21 GMT

If one of the other fields in Table C is fully populated (no null values), then use this field as a filter in a list box or calculated dimension:

=Aggr(If(Len(FieldC1) > 0, ItemD), ItemD)

Otherwise you might need to create a flag field in TableC to perform the filtering

HTH

Jonathan

Re: Table join issue

Mon, 17 Nov 2014 06:29:11 GMT

hey damitha,

try this,

load * from table_C;

left keep(table_C)

load * from table_B;

left keep(table_C)

load * from table_A;

load * from table_C;

load * from table_B where exists(itemID);

load * from table_A where exists(itemID);

cheers,

kunal bhattacharjee

Re: Table join issue

jagan — Mon, 17 Nov 2014 06:43:13 GMT

Hi,

Try this script

Table_C:

LOAD *

FROM table_C;

Table_B:

left keep(Table_C)

LOAD *

FROM

table_B;

Table_A

left keep(Table_C)

LOAD *

FROM

table_A;

Hope this helps you.

Regards,

Jagan.

Re: Table join issue

Mon, 17 Nov 2014 06:45:37 GMT

this will work

Load * From table c;

left join(table c)

load * from table b;

left join(table c)

load * from table a;