expression

[#1]

Hi,

Can anyone help? Syas error in expression:

= If([Q21. Support to help you manage your money])= 'Yes'

Chris

[morganaaron]

= If([Q21. Support to help you manage your money])= 'Yes'

You've closed the If() statement too early - you don't need a bracket at the end of your field name, so remove that! I'm assuming you have more to the expression than just the above?

[reshmakala]

you need to have a if-then or if-then-else in QlikView

if(condition, true_task, [else_task])

else is optional

[francoiscave]

Hi Chris:,

Try this:

= If([Q21. Support to help you manage your money]= 'Yes','ok','ko')

if(condition , then , else)

François

[francoiscave]

Hi Chris,

Have you need some more help ?

If not, can you mark an answer as Correct or helpful to close this thread.

Thanks,

François

[#6]

Hi,

It still says error in expression.

No this is the whole expression. I'm using it in a text box. We just want the text box to show the number of results as opposed to having to use a chart.

Chris

[francoiscave]

Hi Chris,

Can you post an sample app ?

It will be easier to solve your issue.

François

[#8]

Hi,

Please see test application attached.

In the text box you will see the expression noted above but its giving me an error.

Chris

[francoiscave · Accepted solution]

Hi Chris,

See the attached file to get the solution.

I've use the Set Analysis solution with this formula:

=Count({<[Q22. Would you be interested in mutually exchange to a more suitable sized property?]= {'Yes'}>}[Atlas ID])

It's what do you expect ?

BR,

François

[Anonymous]

Hi Chris,

This is quite a common one. Not sure if the example QVW posted below help or not but just in case you can't open these...

=Sum(If([Q21. Support to help you manage your money] = 'Yes',1 , 0))