Oracle NVL function in QLik

[bsbernabe]

Hello There,

what is the equivalent of this Oracle script

nvl((Field_C + Field_B),0)||' Yrs '||nvl((Field_D + Field_E),0) ||' Mnts' "Total Work" to Qlikview?

Any suggestions will be much appreciated!

Best Regards,

Bing

[ngioux · Accepted solution]

Hello,

I think the equivalent in Qlik will be:

Alt(([Field_C] + [Field_B]), 0) & ' Yrs ' & alt(([Field_D] + [Field_E]), 0) & ' Mnts' as [Total Work]

Hope this helps you.

Best Regards,

Nicolas

---

[bsbernabe]

Thank you so much its great now is working....