Filter by another dimension in bar chart

[holymosfet]

Hi!

I have a straight table that contains a BOM of technical installations. I want to be able to filter the Configuration Files that contain the desired items, not the actual rows. Is that possible?

Config File Name	Item Name
FileA	Panel
FileA	Detector
FileA	Software
FileB	Detector
FileB	Software
FileB	Hardware
FileB	Line Element
FileC	Software
FileC	Panel
...

My bar chart's dimension is [Item Name] and the measure is count([Item Name])

Let's assume I click on Panel in the bar chart, I want the filter to be applied in [Config File Name] for FileA and FileC. Is there a way to do that?

Thanks in advance!

[ogster1974]

I think your answer lies in the use of Alternate states as your setting a filter on item in your default state and wanting to use the answer i.e the 2 config files in your other state but including all items relating to those config files.

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

[holymosfet]

Thank you ogster!

I will read in and give it a try

cheers