Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
renuka_sasikumar
Creator III
Creator III

IF condition for <>Null

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

3 Replies
tresesco
MVP
MVP

Try like:

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

jvitantonio
Luminary Alumni
Luminary Alumni

Hello,

You can try this:

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

JV

jagan
Luminary Alumni
Luminary Alumni

Hi,

You can use

if( Len(Trim(SALES_GRP))=0


OR

If(Not Isnull(SALES_GRP))


Hope this helps you.


Regards,

jagan.