Qlik Sense - Passing extra dimensions in selection

[Suvesh]

Hi All,

I am creating a summary sheet with two bar charts (corresponding to each File_Name) using below dataset

File_Name	Category	Sub_Category	Amount
Dev	A	Profit	10
Dev	A	Loss	2
Prod	A	Profit	10
Prod	A	Loss	2

In second sheet, I am showing the above data and linking both the sheets together thus forming summary to detailed navigation.

Problem statement: How to show rows corresponding to a particular file_name whenever I make selection in a particular chart. Lets assume if I choose category as 'A' in my first chart which is corresponding to  file_name as 'Dev', then only two rows should be visible in detailed data. 

Note: File_name is not used as dimension in chart but only used in set analysis.  Also I am using viz-lib bar chart.

Any help would be highly appreciated. Thanks in advance.