Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to everybody,
I have 2 tables with different fields name
TAB A
field A | field B |
---|---|
X | |
and TAB B
field C | field D |
---|---|
X | |
I would have a "link" trough field A and field D, so if I filter on TAB B,
I have the same filter on TAB A.
Is it possible to in QLIKVIEW ?
I hope I was clear,
Regards
Oronzo
TAB A:
Load fieldA as key,
fieldA,fieldB;
TAB B:
Load fieldD as key,
fieldC,fieldD;
Hope it helps you.
This is my load script but the filter doesn't works
TABA:
LOAD A as key,
A,
B
FROM data.xls
(biff, embedded labels, table is work$);
TABB:
Load D as key,
C,
D
FROM data.xls
(biff, embedded labels, table is work$);
Regards
Oronzo
If A and D field has same data values. If possible attach sample file.
Hi Oronzo,
without knowing your data, we only can guess where the real problem is. Load-statements look OK, but how do your Data look like? Do you have corressponding records in Field D to your Field A? Remember: QV works case-sensitive! Also make sure that you don't have blanks or other non-printable characters in your key-Fields.
regards,
Edgar
Hello
this is my example
Regards
Oronzo
Hi Oronzo,
perhaps you should explain the meaning of the columns in your Excel-File. I guess your data from A should correspond to your data from F ????
regards,
Edgar
I have reloaded my example,
I hope that it was more clear.
My target is to understand if two fields of two different tables that are named in a different way
can be connected one filter
Thanks
Oronzo
Hello,
I've seen your data. But there is no common data b/w the fields. If there is common data in anyone of the field you can make a link, Otherwise we can't make link.
But one think i obsered, your are loading the data from one excel sheet only. Why your are loading the dataset in two tables. Ok any way i don't know why? If that is in the case you can use A as common field in both tables. For example,
Load A, B from work;
Load A,C,D from work;
- If i'm wrong, can you explain clearly how is your data.
Let me explain you when can it possible to link the data.
Table1:
A | B |
1 | b1 |
2 | b2 |
3 | b3 |
Table 2:
C | D |
c1 | 1 |
c2 | 2 |
c3 | 3 |
- If your data looks like above, you can link two tables as we worked out previously.
Hi Oronzo,
I think you should differentiate between tables in your datamodel and table objects on your layout. No offense, but I'll strongly recommend you to read some of the very basics of Qlikview (manual, first steps). Otherwise you talk about banana and others understand "apples".
regards,
Edgar