Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)

                           AnswerItem(Column)

 

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

 

 

Labels (2)
1 Reply
Highlighted
Specialist III
Specialist III

Re: Measure Calculation

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