Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
nvl (decode(sign(OS),-1,0,OS),0)
rangemax(0,OS)
NVL-is for checking null values
IF decode(sign(OS))=-1 then 0 else OS
IF NULL = 0
Please convert into Qlik view expression
if(If(OS<0,0,OS)=null(),0,If(OS<0,0,OS))