topic Problem with if statement in QlikView

Problem with if statement

Fri, 06 May 2011 14:48:13 GMT

Hello,

I am trying to do a nested if. The field I am evaluating can either be a number or text. These are lab results. The text part is when the lab enters a result like - '>15'. If it is this, then I'm trying to put in a "1" into my flag field. The statement is not even recognizing this part of my if statement and I can't figure out why. Here's my statement:

if(num([Event Tag]) > 6, 1,

if(text([Event Tag]) = '>15*', 1, 0)) as INR_Flag6

The first part will evaluate correctly, but the second part won't. Any suggestions will be greatly appreciated! I've tried everything I can think of to get this to work.

Thanks,

nmellick

Problem with if statement

erichshiino — Fri, 06 May 2011 14:57:17 GMT

Hi, I didn't understand what you are trying to accomplish with text([Event Tag]) = '>15*',

maybe you could work with part of the string.

For example,

num( left( [Event Tag],2) )> 15

This gets the two characters on the left, convert it to a number and check if it is higher than 15.

If it not it, please describe your if-condition

Rgds,

Erich

Problem with if statement

nagaiank — Fri, 06 May 2011 15:13:16 GMT

In the second 'if' statement, use 'like' operator instead of '='. I tried a sample script and it worked for me.

Krishnamoorthy

Problem with if statement

Fri, 06 May 2011 15:37:45 GMT

Thanks to both of you for responding! The "Like" word fixed my issue.

nmellick

Problem with if statement

Stefan_Walther — Mon, 09 May 2011 17:50:39 GMT

Hi,

if you are struggling with if-statements (like me ) maybe this can be helpfull:

http://www.qlikblog.at/464/tool-creating-nested-ifstatements/

Regards

Stefan