topic Re: expression in QlikView

expression

Wed, 14 Jan 2015 15:28:07 GMT

Hi,

Can anyone help? Syas error in expression:

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

Chris

Re: expression

morganaaron — Wed, 14 Jan 2015 15:29:58 GMT

= 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?

Re: expression

reshmakala — Wed, 14 Jan 2015 15:30:19 GMT

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

if(condition, true_task, [else_task])

else is optional

Re: expression

francoiscave — Wed, 14 Jan 2015 15:30:46 GMT

Hi Chris:,

Try this:

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

if(condition , then , else)

François

Re: expression

francoiscave — Thu, 15 Jan 2015 11:22:58 GMT

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

Re: expression

Thu, 15 Jan 2015 23:50:28 GMT

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

Re: expression

francoiscave — Fri, 16 Jan 2015 08:11:16 GMT

Hi Chris,

Can you post an sample app ?

It will be easier to solve your issue.

François

Re: expression

Tue, 20 Jan 2015 09:30:38 GMT

Hi,

Please see test application attached.

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

Chris

Re: expression

francoiscave — Tue, 20 Jan 2015 10:15:11 GMT

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

Re: expression

Anonymous — Tue, 20 Jan 2015 10:23:25 GMT

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))

Re: expression

avinashelite — Tue, 20 Jan 2015 11:25:02 GMT

Hi Chris,

As per my knowledge IF condition does not go good with text objects try to use set analysis in the text objects it will give the desired the result.