topic Re: Oracle NVL equivalent in Qlikview in QlikView

Oracle NVL equivalent in Qlikview

vipingarg23 — Fri, 01 Sep 2017 12:09:12 GMT

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 — Fri, 01 Sep 2017 12:14:09 GMT

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

vipingarg23 — Fri, 01 Sep 2017 12:17:37 GMT

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

Kushal_Chawda — Fri, 01 Sep 2017 12:18:36 GMT

try this

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

sunny_talwar — Fri, 01 Sep 2017 12:20:11 GMT

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 — Sat, 02 Sep 2017 04:55:52 GMT

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>