This content has been marked as final. Show 5 replies
I want to handle IS NOT NULL in scripting.
In OBIEE, they are using a case statement like,CASE WHEN NOT AMOUNT IS NULL THEN AMOUNT ELSE 0
we can write case statement as IF() statement. but I don't know how to write NOT IS NULL.
I think in QlikView we only ISNULL(), but there is no NOT IS NULL().
Can you help me in writing this.