topic Is there something wrong in this expression? in QlikView

Is there something wrong in this expression?

Mattia — Mon, 21 Oct 2019 15:07:33 GMT

Hi QV users,

i'am writing an expression like the following, but it not works:

If([field1]='not null', If([field2]=030357,'output1','output2')

My goals is to create a new field that show me:

a) output1, if field1 is not null and field2 = 030357

b) output2, if field1 is not null and field2 <> 030357

Is there something wrong?

Thanks,

Mattia

Frank_Hartmann — Mon, 21 Oct 2019 15:05:44 GMT

can u share the rawdata?

Mattia — Mon, 21 Oct 2019 15:11:06 GMT

Sorry Frank, i can't do this now.

Can you help me anyway?

Thanks,

Mattia

Stoyan_Terziev — Mon, 21 Oct 2019 15:12:19 GMT

Hi Mattia,

Please give this one a try:

IF(NOT IsNull([field1]) AND [field2]=030357, 'output1',

IF(NOT IsNull([field1]) AND [field2]<>030357, 'output2', 'output3') )as Output

There needs to be a third output there though. Because there are more than just those 2 options in your equation -> ex: When [field1] is Null

I hope that helps!

Regards,

S.T.

Mattia — Mon, 21 Oct 2019 15:26:08 GMT

Hi Stoyan!

is it possible to have an expression that shows only two options?

Thanks,

Mattia

sunny_talwar — Mon, 21 Oct 2019 15:28:28 GMT

May be this

If(Len(Trim([field1])) > 0, If([field2] = '030357', 'output1', 'output2') )

Mattia — Tue, 22 Oct 2019 07:48:58 GMT

Thanks Sunny!

It works perfectly!!!

Mattia