topic Re: If Statement Issue in QlikView

If Statement Issue

Thu, 09 Jul 2015 18:04:01 GMT

I am trying to use an If Statement which should change the Value of another field. For Example

If(Field1='A', Field2='X',Field2) as New_Field.

How can I accomplish this

Re: IF STATEMENT ISSUE

Anonymous — Thu, 09 Jul 2015 18:06:37 GMT

Hi,

if I undestand right:

If(Field1='A', 'X',Field2) as New_Field.

Regards.

Re: IF STATEMENT ISSUE

MK_QSL — Thu, 09 Jul 2015 18:09:27 GMT

IF(Field1 = 'A' and Field2 = 'X', Field2) as NewField

Re: IF STATEMENT ISSUE

Thu, 09 Jul 2015 18:10:41 GMT

No what I had was right , I want Field2 Value to be dependent on Field1.

For Example

If(Category='Tennis', then Activity='Sports' else Activity)

Re: IF STATEMENT ISSUE

Thu, 09 Jul 2015 18:13:00 GMT

No what I had was right , I want Field2 Value to be dependent on Field1.

For Example

If(Category='Tennis', then Activity='Sports' else Activity)

Re: IF STATEMENT ISSUE

Anonymous — Thu, 09 Jul 2015 18:17:10 GMT

Excuse me but I dont understand.

Is this?

If(Field1='Tennis', ' Sports' , Field2) as Field2

Or Field2 is a new field?

So is:

If(Field1='Tennis', ' Sports' , 'Other') as Field2

Re: IF STATEMENT ISSUE

daniel_kusiak — Thu, 09 Jul 2015 18:22:18 GMT

If(Category='Tennis', then Activity='Sports' else Activity)

IF(Field1 = 'A',Field2,Field2) as NewField

Re: If Statement Issue

Anonymous — Thu, 09 Jul 2015 18:26:11 GMT

If(Field1='A' and Field2='X',Field2, null()) as New_Field.

Re: IF STATEMENT ISSUE

MK_QSL — Thu, 09 Jul 2015 18:26:35 GMT

If(Field1='A', 'X', Field2) as New_Field

If(Category = 'Tennis', 'Sports', Activity) as FieldName

Re: If Statement Issue

Anonymous — Thu, 09 Jul 2015 18:27:29 GMT

if you still have an issue post us sample data in excel sheet

Re: If Statement Issue

Anonymous — Thu, 09 Jul 2015 18:29:11 GMT

i think Manish answered your question. Let us know if that does not fix your problem

Re: If Statement Issue

Anonymous — Thu, 09 Jul 2015 18:31:03 GMT

If(Category = 'Tennis', 'Sports', Activity) as Activity

Re: If Statement Issue

Thu, 09 Jul 2015 19:01:22 GMT

Thanx for ur help, but here is the sample data

LOB	ISSUECODE
X	N
Y	N
Z	N
C	R

What I want is

If (LOB='Z' then change ISSUECODE ='R',ISSUECODE)

Re: IF STATEMENT ISSUE

Thu, 09 Jul 2015 19:01:32 GMT

Thanx for ur help, but here is the sample data

LOB	ISSUECODE
X	N
Y	N
Z	N
C	R

What I want is

If (LOB='Z' then change ISSUECODE ='R',ISSUECODE)

Re: IF STATEMENT ISSUE

Thu, 09 Jul 2015 19:01:42 GMT

Thanx for ur help, but here is the sample data

LOB	ISSUECODE
X	N
Y	N
Z	N
C	R

What I want is

If (LOB='Z' then change ISSUECODE ='R',ISSUECODE)

Re: IF STATEMENT ISSUE

MK_QSL — Thu, 09 Jul 2015 19:02:26 GMT

If (LOB='Z','R',ISSUECODE) as ISSUECODE

Re: IF STATEMENT ISSUE

Thu, 09 Jul 2015 19:17:16 GMT

Still not working

here is the current Expression

iF(ISSUE0CODE_Combo='N' OR( ISSUE0CODE_Combo='M' AND MANUAL_CODE_DISTRIBUTION='NB') ,'N',

iF(ISSUE0CODE_Combo='R' OR ( ISSUE0CODE_Combo='M' AND MANUAL_CODE_DISTRIBUTION='RB') OR ISSUE0CODE_Combo='PRF' ,'R',

If(LOB='PRF','R',NULL()))) AS IssueCode_Current,

sample data

LOB ISSUECODE ISSUECODE_COMBO

A R

PRF N PRF

Re: IF STATEMENT ISSUE

sasiparupudi1 — Sat, 11 Jul 2015 18:20:11 GMT

You can only achieve this sort of if condition if you manually iterate through the table records and it is not possible in the preceding loads. please see the attachement. Hope this helps.

Re: If Statement Issue

sasiparupudi1 — Tue, 14 Jul 2015 11:20:35 GMT

Did you find your answer?

Sasi

Re: IF STATEMENT ISSUE

kavita25 — Tue, 14 Jul 2015 13:00:38 GMT

PFA

Hope it helps you.

Regards,

Kavita