Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
philip_radovich
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 (1)
1 Reply
krishna_2644
Specialist III
Specialist III

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