Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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
Partner - Champion III
Partner - Champion III

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))