Linking fields

[AmCh]

Hi all,

I have the following fields as an example:

System

A1

A2

A3

B1

B2

B3

C1

C2

Subsystem A

A1

A2

A3

Subsystem B

B1

B2

B3

Subsystem C

C1

C2

Desired output:

Based on selections in Subsystems (A,B and C) I want to notify (with symbol, text e.g. 'selected',...) in field System, which values are selected in subfields.

Supposing: A1, B3 and C2 are selected in fields Subsystem A,B & C respectively from the end user.

Results in field System:

System

A1    selected

A2

A3

B1

B2

B3   selected

C1

C2   selected

Any help please?

Thanks in advance

[PadmaPriya · Accepted solution]

Hello @AmCh 

Please refer to below article:

How To Remove Synthetic Keys in Qlikview (analyticsvidhya.com)

Thanks,

Padma Priya

Qlik Support