topic Re: Show all possible values with common ID when filtering one in App Development

Show all possible values with common ID when filtering one

Femke_DPG — Fri, 14 Oct 2022 12:04:54 GMT

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

Re: Show all possible values with common ID when filtering one

TusharCC — Fri, 14 Oct 2022 12:24:21 GMT

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/SetAnalysis/set-modifiers-implicit-field-value-definitions.htm?_ga=2.59286187.784496277.1665721068-54110136.1636361895&_gac=1.209003174.1665742129.EAIaIQobChMI5tC907zf-gIVk5NmAh0PSQuiEAAYASAAEgKxt_D_BwE

Thanks,

Re: Show all possible values with common ID when filtering one

Femke_DPG — Fri, 14 Oct 2022 12:21:44 GMT

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

Re: Show all possible values with common ID when filtering one

Femke_DPG — Fri, 14 Oct 2022 12:29:30 GMT

Then I only get the selected advertiser

Re: Show all possible values with common ID when filtering one

Femke_DPG — Fri, 14 Oct 2022 13:37:41 GMT

That worked! But like that:

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

Thanks a lot!