Dual Condition Table Filter

[nickmarlborough]

I have a link table set up with as follows:

ID	Intial
123	NM
123	JK
456	LL

From this, i connect to different data sets (the majority connect on ID however some connect to initial). One of the files connected is ID Details where it provides the 'Umbrella' the ID rolls up into. A different file that connects to the Initial column, provides the 'Team' the ID rolls up into. 

I am focused on: Umbrella = GG & Team = HH

It is worth noting....not all staff that map to a GG ID are HH and not all HH are mapped to an ID. 

The table i am looking to create is essentially a 'show the values if Umbrella = GG OR if Team = HH

ID	Umbrella	Name	Team
123	GG	NM	HH	Mapped
123	GG	JK	HH	Mapped
456	GG	LL	QQ	Mapped
No ID	-	KK	HH	Unmapped
777	II	OK	HH	Mapped

If you notice there might be occassions where:

1. Non-HH Name is mapped to a GG ID

2. HH Name mapped to Non-GG ID

3. HH Staff not mapped to an ID

Please help! is this something i need to do in the load editor?

[Anil_Babu_Samineni]

@nickmarlborough Question is confusing, Can you maybe help the input data and expected result?

[rwunderlich]

The set expression for "Umbrella = GG OR if Team = HH" would be

{<Umbrella={'GG'}> + <Team={'HH'}>}

Where you use this depends on exactly what you want to show in your chart. If you are just trying to display those dimension values as shown in your example, then you could use a calculated dimension for ID like:

Aggr(Only({<Umbrella={'GG'}> + <Team={'HH'}>} ID), ID)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com