Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if(isnull) statement

Try to use this formula but i'm getting 'Error in Expression: If takes 2-3 parameters'

Help me with this to work properly.

if(isnull([SHIP_DT]) = false and isnull([P_RETURN_DT])=false) then

(sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));

else if(isnull([SHIP_DT])=false and isnull([P_RETURN_DT])=true) then

sum(([SALE_RPRICE])*([ORDER_QTY]));

else

'0';

end if

Thank you

3 Replies
sushil353
Master II
Master II

Try this:

if not isnull([SHIP_DT])  and not isnull([P_RETURN_DT]) then

(sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));

else if not isnull([SHIP_DT]) and isnull([P_RETURN_DT]) then

sum(([SALE_RPRICE])*([ORDER_QTY]));

else

'0';

end if

Not applicable
Author

Thanks for the reply,

but i'm getting 'Grabage after expression: 'not'

sunny_talwar

How about this?

If(Len(Trim([SHIP_DT])) > 0 and Len(Trim([P_RETURN_DT])) > 0, Sum(([SALE_RPRICE])*([ORDER_QTY])) * (-1),

If(Len(Trim([SHIP_DT])) > 0 and Len(Trim([P_RETURN_DT])) = 0, Sum(([SALE_RPRICE])*([ORDER_QTY])), 0))