topic Re: Conditionals Chain in QlikView

Conditionals Chain

Fri, 30 May 2014 14:03:52 GMT

Hello!

I have the following conditionals on my script to mark with a flag if I have an anomaly or not:

IF (FLAG_ANOMALY = 1, 'With Anomaly',

IF (FLAG_ANOMALY = 0 AND FLAG_INSPECTION = 1, 'No Anomaly',

'Pending')) AS FLAG_ANOMALY_TYPE

The thing is that I get some rows with null and I want that everything that is not 'With Anomaly' / 'No Anomaly' get the value 'Pending'.

What could it be?

Thank you!!!

Re: Conditionals Chain

Fri, 30 May 2014 14:07:20 GMT

IF (FLAG_ANOMALY = 0 AND FLAG_INSPECTION=1,'No Anomaly',IF(FLAG_ANOMALY=1,'With Anomaly','Pending'))

Re: Conditionals Chain

Fri, 30 May 2014 14:08:42 GMT

The other thing is if you are adding new fields after your initial calculation i.e. concatenating new rows of data and you haven't included your if statement

Re: Conditionals Chain

Anonymous — Fri, 30 May 2014 14:09:59 GMT

I assume that there are records where FLAG_ANOMALY is not 1 neither 0. How do you want to handle this?

Re: Conditionals Chain

antoniotiman — Fri, 30 May 2014 14:12:51 GMT

In the Script use

NullAsValue Flag_Anomaly ;

Set NullValue = 'Pending';

Regards

Re: Conditionals Chain

Fri, 30 May 2014 14:14:22 GMT

But I previously have a table in my script where I do the following:

IF (NOT ISNULL (ANOMALY_TYPE), 1, 0) AS FLAG_ANOMALY,
IF (NOT ISNULL (INSPECTION_TYPE), 1, 0) AS FLAG_INSPECTION

So I suppose I should assign a value for every type of anomaly...

If not, I'd like to put 'Pending' for the remaining records.

Re: Conditionals Chain

Anonymous — Fri, 30 May 2014 14:17:35 GMT

In this case the response from Felim Shanaghy is what you need.

Re: Conditionals Chain

Fri, 30 May 2014 14:18:22 GMT

Okay, I'm going to try it. Thank you!