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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional between interval

I need to make a condition where 1 is when a value is from -7 to 7 and 0 when you have outside that range, does anyone know how this condition is in QlikView? Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

if( MyValue >= -7 and MyValue <=7,1,0)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

if( MyValue >= -7 and MyValue <=7,1,0)


talk is cheap, supply exceeds demand
Not applicable
Author

Oh... so simple.... dumb question... thanks!