Dear all,
I have data looking like the format below. I want to set-up a filter pane which shows 'score 1, score 2 and score 3' as filtering options.
Next to the filter pane I have a bar chart, which shows the sum of the scores per category.
So if a select one of the filters, the bar chart should only show me the sum of that score.
Can this be done in QlikSense?
Thanks
| Category | score 1 | score 2 | score 3 |
| A | 3 | 3 | 5 |
| B | 4 | 4 | 2 |
| C | 2 | 5 | 3 |
| A | 6 | 2 | 1 |
| A | 2 | 3 | 5 |
| C | 2 | 4 | 2 |
| D | 3 | 4 | 5 |
| C | 5 | 4 | 6 |
| B | 6 | 2 | 7 |
| B | 7 | 3 | 3 |
