Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table join issue

Dear friends,

I have three tables call table_A,table_B and table_C.

Capture.JPG.jpg

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.

7 Replies
sushil353
Master II
Master II

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

sujeetsingh
Master III
Master III

Load table C

;;;

;;From:

Left join Table A

'''

'''' from ;

left join table B;

anbu1984
Master III
Master III

Table_C:

Load * From Table_C;

Left Join(Table_C)

Load * From Table_B;

Left Join(Table_C)

Load * From Table_A;

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

hey damitha,

try this,

load * from table_C;

left keep(table_C)

load * from table_B;

left keep(table_C)

load * from table_A;

or

load * from table_C;

load * from table_B where exists(itemID);

load * from table_A where exists(itemID);

cheers,

kunal bhattacharjee

jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

this will work

Load * From table c;

left join(table c)

load * from  table b;

left join(table c)

load * from table a;