topic connecting tables made with linked key fields in QlikView

connecting tables made with linked key fields

becki_kain — Wed, 25 Nov 2020 16:16:04 GMT

(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

Re: connecting tables made with linked key fields

rahulpawarb — Thu, 17 Aug 2017 06:13:33 GMT

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

Re: connecting tables made with linked key fields

becki_kain — Thu, 17 Aug 2017 19:33:36 GMT

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