topic Re: IF condition for <>Null in QlikView

IF condition for <>Null

renuka_sasikumar — Fri, 19 Sep 2014 09:43:57 GMT

Hi,

I have Sales Data where I want to have Sales_Value under the condition

WHERE SALES_OFF<>Null

SALES_GRP<>Null

& Division<>XYZ

How can I get the Value.

I tried by this at Scripting Level as well as in Front END but its not working.

=if(SALES_GRP<>' ' AND SALES_OFF<>' ' AND Division<>'XYZ',Sales_Value )

Can anyone plz help me.

Thanks & Regards,

Renuka

tresB — Fri, 19 Sep 2014 09:45:36 GMT

Try like:

if( Len(Trim(SALES_GRP))=0 AND Len(Trim(SALES_OFF))=0 AND Division<>'XYZ',Sales_Value )

jvitantonio — Fri, 19 Sep 2014 09:46:37 GMT

Hello,

You can try this:

if(NOT ISNULL(SALES_GRP) AND NOT ISNULL(SALES_OFF) AND Division <> 'XYZ', Sales_Value) AS Sales_Value;

jagan — Fri, 19 Sep 2014 09:49:17 GMT

Hi,

You can use

if( Len(Trim(SALES_GRP))=0

If(Not Isnull(SALES_GRP))

Hope this helps you.

Regards,

jagan.