Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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))