Filtering for distinct key value to aggregate on a different value

Wed, 08 Oct 2014 22:15:51 GMT

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?

Currently my dimension is:

=round(TotalScore,[Bin Width])

Expression:

count(TotalScore)

Thanks in advance,

Briana

topic Filtering for distinct key value to aggregate on a different value in QlikView

Filtering for distinct key value to aggregate on a different value