Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Please convert the Oracle syntax into qlik view expression

nvl (decode(sign(OS),-1,0,OS),0)

3 Replies
Gysbert_Wassenaar

rangemax(0,OS)


talk is cheap, supply exceeds demand
Not applicable
Author

NVL-is for checking null values

IF decode(sign(OS))=-1 then 0 else OS

IF NULL = 0

Please convert into Qlik view expression

sujeetsingh
Master III
Master III

if(If(OS<0,0,OS)=null(),0,If(OS<0,0,OS))