Show all possible values with common ID when filtering one

[Femke_DPG]

Hi all, 

An advertiser has a corresponding category. When I filter on one advertiser, I would like to see all the other advertisers with the same category. 

For example: Aldi has category 'Food & Distribution'. I would also like to see Colruyt, Albert Heyn, Delhaize, ... automatticaly when filtering on Aldi. 

Can anyone help me please? 

Thanks a lot!

Femke

[TusharCC · Accepted solution]

Implicit set analysis,  using P().

For example,

=only({$<AdvertiserID=P(AdvertiserID), Category>}Advertiser_Name)

For more clarity go through below link,

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

Thanks,

[Femke_DPG]

Thanks, but it must be depending on filter.

So when I filter on Aldi (advertiser) it must know that aldi has the category 'Food & distribution'. Without filting on category, it must show all possible advertisers with the same category. But without filtering on category and ignoring filter advertiser.

I hope it's clear, it's difficult to describe 🙂

Thx

[Femke_DPG]

Then I only get the selected advertiser 

[Femke_DPG]

That worked! But like that:

=only({$<[Product Category Name]=P([Product Category Name]), Advertiser>}[Advertiser Holding])

Thanks a lot!