Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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:

StudentidQuestion#TotalScore
1150%
1250%
1350%
2170%
2270%

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

0 Replies