connecting tables made with linked key fields

[becki_kain]

(new to qlik, coming from the ACL world.  sorry if this is remedial)

my boss made me an excel file which has the keys/unique fields for every other table.  I need to read this in and then read in (and i'll do it manually since i'm short on time) all these other tables.  how do I link them, through the unique field key table which has all unique fields, in qlik where table A will have the unique key ABC and then data for ABC and table B will have unique key of DEF and data for it, and we want to be able to link them of table A->key table for key for A, B->table B, to on the fly?

thanks

becki kain

[rahulpawarb]

You can make use of aliasing (refer below sample script):

A:
LOAD * INLINE [
ABC, Id
123, 1
456, 4
789, 7
];


B:
LOAD DEF AS ABC, Value INLINE [
DEF, Value
123, 1000
456, 4000
789, 7000
];

Regards!

Rahul Pawar

[becki_kain]

what I had to do was create the inner table then the "spokes" had the same header field so qlik automatically linked all the tables.  What I did was then create bar charts with "date" (not date time, 500 per day) on the X axis and stacked bar charts on the other.

How do I change scales though - where one measurement is "available megabytes" and one is "% of total page space"?  the scales are completely off, of each other, so how do I scale down one, so the bar charts are meaningful?

thanks

becki kain