I am new to qlik sense,
I have a bar chart I need to select a bar and then see the count of repetition of values from another column, so that bar acts as a filter. The data contains name, amount and category. The bar chart contains customers as dimension and measure as amount(sum). When I select any bar(say customer A) then in the kpi I need to see the count of categories like - foods - 29, clothes - 12, gadgets - 7. Only three categories are there in the category column.