Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH 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.