Filter pane based on column headers

[Essevee]

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

[anushree1]

Hi,

Please check the attached file

[Shubham_Deshmukh · Accepted solution]

Have u tried CROSSTABLE??

Regards,

Shubham