topic Re: Linking two tables in QlikView

Linking two tables

AmCh — Fri, 14 May 2021 19:15:56 GMT

Hi all,

I have as an example the following table and fields:

Table_a

Systems	Value_a	Value_b
A1	...
A2
A3
B1
B2
B3
C1
C2		...

and independent fields:

System A

System B

System C

Input:

Enduser selects from each Field (System A, B and C) a value. As an example hier: A1,B1 and C1.

Desired output:

Field Systems from Table_a should based on the previous selections show only A1,B1 and C1 and there the enduser can select a value between A1, B1 and C1 from the same field.

Any help please?

Thanks in advance.

Re: Linking two tables

OceanView — Fri, 14 May 2021 20:59:48 GMT

I would recommend creating 3 inline tables, one for each of the System A, B, C

load* inline [
SystemA
A1
A2
A3
];

Then, in the dimensions field, you can create a calculated dimension like this:

=if(SubStringCount(GetFieldSelections(SystemA),Case),Case,if(SubStringCount(GetFieldSelections(SystemB),Case),Case,if(SubStringCount(GetFieldSelections(SystemC),Case),Case,'')))

This will result in nothing showing if there are no selections for System A, System B, or System C. You can create a Document Settings/Trigger such that if nothing is selected, all of them get selected for the the System selections.

Re: Linking two tables

AmCh — Sat, 15 May 2021 12:47:23 GMT

Thanks @OceanView for your reply.

I don't want to create a new dimension field. I want only to make changes on existing field, from which other fields from the same table are depending.

Changes: Based on previous selections, the already existing field should 'ban' the remaining non selected values.

I want to preserve the field Systems and not to create a new one, because based on it I have other calculations to perform.

I hope that you understand my issue and to help me further!

Thanks in advance.

Re: Linking two tables

Qrishna — Sun, 16 May 2021 04:35:50 GMT

Check the attached qvw.

thnx

Re: Linking two tables

AmCh — Sun, 16 May 2021 21:56:23 GMT

@Qrishna Thanks for your reply.

The idea linking tables with creating a commun key is good, but it has a problem that by choosing A1, you're imposing choosing B1 and C1 (because you setted for A1, B1 and C1 the key value=1).

Any help please?

Thanks in advance.