Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Measure Calculation

I am creating a pivot table for survey results. I would like the measure to be a percentage of responses per answer item per question. Using the following measure Count(AnswerItem)/Count(Total(Question)) it works when I have 1 question selected. I am trying to use the aggr function so each count(total(question)) is independent from the overall count so if I remove the filter it will still calculate the percentage of responses for each answer item. Any help would be greatly appreciated. 

Dimensions: Question(row)



Measure: Count(AnswerItem)/Count(Total(Question))



Labels (2)
1 Reply
Specialist III
Specialist III

Hi. Could you please provide some sample data and expected results?