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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
fanninam
Creator
Creator
‎2018-01-19 01:22 PM

Between

The red and green below are working but I forgot the syntax for how to do yellow:

   If(CurrentRatingOverall >= '2.5',1) AS Green,
// If(CurrentRatingOverall >1.4 <2.5,1) AS Yellow,
   If(CurrentRatingOverall < '1.5',1) AS Red,

372 Views
0 Likes
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP
‎2018-01-19 01:25 PM

For Logic operator you should written AND like

If(CurrentRatingOverall >1.4 and CurrentRatingOverall <2.5,1) AS Yellow,

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

341 Views
1 Reply
Anil_Babu_Samineni
MVP
MVP
‎2018-01-19 01:25 PM

For Logic operator you should written AND like

If(CurrentRatingOverall >1.4 and CurrentRatingOverall <2.5,1) AS Yellow,

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
342 Views