Oracle NVL equivalent in Qlikview

[vipingarg23]

Hi Team,

What is NVL equivalent in Qlikview. I am using Alt (As my data is numeric) and Isnull() but anyone is not giving me expected data.

I am using below:

=if(ALT(A,0)=0 OR ALT(B,0)=0,0,A)

When I am using NVL in oracle it is impacting data but When I am using the same in Qlikview through Isnull or Alt, it doesn't impacting the data.

[Anil_Babu_Samineni]

If NVL is number / value the Alt is similar to NVL

[vipingarg23]

Yes..Right..I am using the same but I am not sure why it is not working.

[Kushal_Chawda]

try this

=if(isnull(A) or isnull(B),0,B)

[sunny_talwar]

How about this

If(Len(Trim(A)) = 0 or Len(Trim(B)) = 0, 0, A)

or do you need an AND condition?

If(Len(Trim(A)) = 0 and Len(Trim(B)) = 0, 0, A)

[vipingarg23 · Accepted solution]

Everything is working. Thanks guys for your help.

I was doing mistake. I have to use the AGGR function. After that both

options are working.

On Fri, Sep 1, 2017 at 5:50 PM, Sunny Talwar <qcwebmaster@qlikview.com>