Filtering for distinct key value to aggregate on a different value
Hi Folks,
I am attempting to create a histogram(http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/13/recipe-for-a-histogram) where I show a distribution of test scores. Because our team needs to be able to do a question level analysis in a separate part of the dashboard, each row in the table is distinct by each question and student pairing (both separate columns), not by each student. We have a column for the total score for each student, but this is repeated in each row.
Example:
Studentid
Question#
TotalScore
1
1
50%
1
2
50%
1
3
50%
2
1
70%
2
2
70%
Is there a way in the expression to filter for the distinct student ids, so that the histogram only aggregates the total scores once?
