topic Re: Oracle NVL function in QLik in QlikView

Oracle NVL function in QLik

bsbernabe — Sat, 16 Nov 2024 01:31:56 GMT

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 — Mon, 13 Jan 2020 14:03:13 GMT

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 — Wed, 15 Jan 2020 02:02:26 GMT

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