Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rich_Talbot
Contributor
Contributor

Expression Not Calculating

Can anyone tell me what is wrong with the following expression:

=Count({<$(vNumber)={'Strongly agree'}>}$(vNumber)
/
Count({<$(vNumber)={'Strongly agree','Agree','Disagree','Strongly disagree'}>}$(vNumber)

 

i am trying to work out the percentage of strongly agree answers out of total responses. 

I am trying to create a variable so i can flick between the questions however the above formula is not calculating

Labels (2)
3 Replies
anushree1
Specialist II
Specialist II

')' seems to be missing at the end, could you try this:

=Count({<$(vNumber)={'Strongly agree'}>}$(vNumber))
/
Count({<$(vNumber)={'Strongly agree','Agree','Disagree','Strongly disagree'}>}$(vNumber))

Rich_Talbot
Contributor
Contributor
Author

Yeah that fixed the formula but it still isn't calculating, i think there is something wrong with the variable 

jonathandienst
Partner - Champion III
Partner - Champion III

As you say there may be a problem with the variable. I suggest that you outline what is in that variable, and how it is created, perhaps with some sample values. If it's a field name, then does it need to be enclosed with delimiters (eg the field name contains spaces)?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein