topic syntax for IF ...... THEN statement in QlikView

syntax for IF ...... THEN statement

Fri, 02 Mar 2012 10:37:03 GMT

Hi,

I need to create a field with the following condition:

if ( A = '1' and B = '1' and C = '2', THEN customer = ' shop1', customer) AS newCustomer

My issue is that I need certain conditions to be met and I need to say when they are met that customer = 'Shop1' as a new field.

Im not sure how to write the THEN condition....

Any ideas?

Regards,

Gregg

syntax for IF ...... THEN statement

CELAMBARASAN — Fri, 02 Mar 2012 10:40:44 GMT

Hi,

You mean like this

Load

if (A = '1' and B = '1' and C = '2', ' shop1', customer) AS newCustomer

..From..

Celambarasan

Re: syntax for IF ...... THEN statement

v_iyyappan — Fri, 02 Mar 2012 10:47:30 GMT

Hi,

I attached sample QV . Hope its helpful for u.....

Regards,

Iyyappan

syntax for IF ...... THEN statement

jagan — Fri, 02 Mar 2012 10:47:56 GMT

Hi,

Try this

TableName:

LOAD

Field1,

Field2,

if ( Field1 = 1 AND Field2 = 2, 'Shop1', 'Default Value') AS newCustomer

FROM DataSource;

Regards,

Jagan.

syntax for IF ...... THEN statement

Fri, 02 Mar 2012 10:48:28 GMT

Hi,

Its a preceding load so the full syntax is:

TableName:

LOAD

if ( A = '1' and B = '1' and C = '2', THEN customer = ' shop1', customer) AS newCustomer

The above statement is not working and I think it is to do with the THEN part of it..

Regards,

Gregg

syntax for IF ...... THEN statement

CELAMBARASAN — Fri, 02 Mar 2012 10:50:28 GMT

Hi,

Inside load no need to use then statement.

Script should be like this.

TableName:

LOAD

if ( A = '1' and B = '1' and C = '2', ' shop1', customer) AS newCustomer

Celambarasan

syntax for IF ...... THEN statement

Fri, 02 Mar 2012 10:54:53 GMT

Hi,

Thanks, I seen my issue now - my mistake.

I was explicitly renaming the customer field using THEN but there was no need.

Regards,

Gregg