How to decouple two tables for a field but still keep them connected with another field

[#1]

Hello guys,

I have a tricky problem and hoped you guys will be able to help.

I will try to give you the essence of the problem.

I have two tables A and B with fields fld1, A_fld2, A_fld3

Table B has fld1, B_fld2, B_fld3, B_fld4

both tables are connected by fld1 so I can filter both of them using fld1.

I also have B_fld4 for table 2 and whenver I select a value for B_fld4, I lose all my Table A data eventhough I have fld1 selected.

So, my question is, is there a way to couple two tables using a field (fld1) and then when I select B_fld4 only table B gets filetered further?

From chart perspective, i can do set analysis to exclude the fld4 selection but I want this to work for the entire dashboard. (other columns, multiboxes etc..)

Thanks in advance.

[peter_turner]

Hello,

Sounds like its something funny with your data, it might not be linking the fields correctly.

You an press ctrl T to view the links between the tables.
Also make a normal table box with all your fields from table A and B, and see if it looks correct.
It might all be working ok, you could just have a value in B_fld4 that does'nt have any matching records in Table A (i've had this before and the problem was my data).

Thanks,
Peter.

[#3]

I have found i can Accomplish a similar thing by loading the Table twice using an aliasname to rename fields i dont want joined. My expressions can then reference fields as Sum(Table2.field1)

ie:

Table1:
Load * from ...QVD

table2:
Load
field1 as Table2.Field1
... from resident Table1

Because all the Fields in Table2 have been aliased this table has no joins (you can then just Rename the field you require to join this table on.

I guess its not very efficient But seems to meet my requirements

ColinR