Qlik Sense - Passing extra dimensions in selection
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.
