Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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>
If NVL is number / value the Alt is similar to NVL
Yes..Right..I am using the same but I am not sure why it is not working.
try this
=if(isnull(A) or isnull(B),0,B)
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)
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>