Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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