topic Re: case when not 'attr1' is null implementation in script in QlikView

case when not 'attr1' is null implementation in script

Fri, 09 Aug 2013 06:02:15 GMT

How to implement the below in qlickview script

i.e is not null concept in qlik view script

case when not ATTR1 is null then ATTR1

when not ATTR2 is null then ATTR2

when not ATTR3 is null then ATTR3

else 'N/A' end "Hold_Reasons"

sivarajs — Fri, 09 Aug 2013 06:52:30 GMT

if(not isnull(ATTR1 ),ATTR1 ,

if(not isnull(ATTR2 ),ATTR2,

if(not isnull(ATTR3 ),ATTR3,'N/A')))

if(isnull(ATTR1 )<>-1,ATTR1 ,

if(isnull(ATTR2 )<>-1,ATTR2,

if(isnull(ATTR3 )<>-1,ATTR3,'N/A')))

Fri, 09 Aug 2013 10:48:32 GMT

It's working thank you

Anonymous — Fri, 09 Aug 2013 10:53:16 GMT

I use this syntax :

IF(LEN(TRIM(ATTR1))=0,ATTR1,
IF(LEN(TRIM(ATTR2))=0,ATTR2,
IF(LEN(TRIM(ATTR3))=0,ATTR3,'N/A'))) AS Hold_Reasons

This will work for blank spaces and null values.

I hope this helps!

Regards

MultiView

rlp — Mon, 12 Aug 2013 07:55:54 GMT

You should replace '=' by '<>'. Otherwise, you obtain only NULL values..

You should even write:

if( Len(Trim(_)) , ATTR? , ... )