topic EXPRESSION PROBLEM in QlikView

EXPRESSION PROBLEM

rohitians — Wed, 03 Apr 2013 06:25:05 GMT

Hello,

if(ISNULL(PROD_GROUP_NAME) OR LEN(PROD_GROUP_NAME)=0,1,0) AS IsMissingProductGrp,

if(ISNULL(THERAPEUTIC_NAME ) OR LEN(THERAPEUTIC_NAME )=0,1,0 ) AS IsMissingProductTherapy,

In the above two expressions i want to add one condition in the first one is if PROD_ID=0 then i need IsMissingProductGrp as 1

add if THERAPEUTIC_NAME=OTHERS then i need IsmissingProductTherapy as 1,

Thanks and Regards,

Rohit

kaushiknsolanki — Wed, 03 Apr 2013 06:41:08 GMT

Hi,

Try this.

if(PROD_ID = 0,1,

if(ISNULL(PROD_GROUP_NAME) OR LEN(PROD_GROUP_NAME)=0,1,0)) AS IsMissingProductGrp,

and

If(THERAPEUTIC_NAME = 'OTHERS',1,

if(ISNULL(THERAPEUTIC_NAME ) OR LEN(THERAPEUTIC_NAME )=0,1,0 )) AS IsMissingProductTherapy

Regards,

Kaushik Solanki

rohitians — Wed, 03 Apr 2013 06:52:30 GMT

It was small but I am learning thanks for your support...