topic Re: Trouble with If Statement in QlikView

Trouble with If Statement

Anonymous — Tue, 27 Jun 2017 23:08:42 GMT

Getting an odd result working with an If statement combined with Match.

Basically trying to determine if a variable includes a specific string, then perform a calulation depending on whether the specific string is there or not.

If(wildmatch(vVariable,'abc'), sum(field1)+((sum(field2)-sum(field3)),sum(field4)+((sum(field5)-sum(field6))

what I'm experiencing is it will not perform the calculation when the variable does not contain 'abc'. I know the calculations work as I have done them separately. I've noticed this works fine if I remove the addition (the bold part). Can I not do addition with If statement?

Re: Trouble with If Statement

Anil_Babu_Samineni — Wed, 28 Jun 2017 01:49:37 GMT

When you remove bold part you mention it is working, So that mean your condition may like below

If(wildmatch(vVariable,'abc'), sum(field1),sum(field4))

So, Then What if you use something like below

If(wildmatch(vVariable,'abc'), sum(field2)-sum(field3),sum(field5)-sum(field6))

Finally, You have extra parenthesis in your expression where i assume, I would ask you to try this, May be

If(wildmatch(vVariable,'abc'), sum(field1)+((sum(field2)-sum(field3)),sum(field4)+((sum(field5)-sum(field6))

Instead of above one please use this - I removed and added one more red colour parenthesis("(" and ")") only

If(wildmatch(vVariable,'abc'), sum(field1)+(sum(field2)-sum(field3)),sum(field4)+(sum(field5)-sum(field6)))

Re: Trouble with If Statement

Anonymous — Wed, 28 Jun 2017 02:31:35 GMT

I figured it out. It actually had to do with a string function issue (that I did not include in my post as I didnt think that was the issue). Thanks