
Re: Multiple If/than color expressions
julien saint maxent Feb 3, 2015 3:21 PM (in response to William Wagner)hi,
your problem is the sign line 2.
if (Sum ( [ISSUES P1Critical] ) <10, lightgreen(),
if( Sum ( [ISSUES P1Critical])=>10 and Sum ( [ISSUES P1Critical])<=50,
Yellow(), lightRed() ) )
=> doesn't work
>= works
Sign: = />= / <=
Julien

Re: Multiple If/than color expressions
William Wagner Feb 3, 2015 3:40 PM (in response to julien saint maxent)Julien,
Thank you for that sign help. I no longer get an expression error, however, I am not getting a 3 color variant.
if (Sum ( [ISSUES P1Critical] ) <10, lightgreen(), if( Sum ( [ISSUES P1Critical])<=10 and Sum ( [ISSUES P1Critical])>=50, Yellow(), lightRed()))
All Numbers <10 are green (that is good)
All numbers equal to or greater than 10 and less than 50 are red, the middle range between 10 and 50 is not yellow, its red too, is not getting picked up at all. is there a better way in QlikSense to write the logical clause?

Re: Multiple If/than color expressions
Robert Mika Feb 3, 2015 3:51 PM (in response to William Wagner)Change the signs
if (Sum ( [ISSUES P1Critical] ) <10, lightgreen(), if( Sum ( [ISSUES P1Critical])>=10 and Sum ( [ISSUES P1Critical])<=50, Yellow(), lightRed()))

Re: Multiple If/than color expressions
William Wagner Feb 3, 2015 4:43 PM (in response to Robert Mika )Thank you so much. I very much appreciate your guidance.




Re: Multiple If/than color expressions
julien saint maxent Feb 3, 2015 3:49 PM (in response to William Wagner)if (Sum ( [ISSUES P1Critical] ) <10, lightgreen(),
if( Sum ( [ISSUES P1Critical])<=10 and Sum ( [ISSUES P1Critical])>=50, Yellow(),
lightRed()))
your expression is contradictory because line 1 you want <10 and line 2 <=10
all sign are reversed.
Try this:
if (Sum ( [ISSUES P1Critical] ) <10, lightgreen(),
if( Sum ( [ISSUES P1Critical])>=10 and Sum ( [ISSUES P1Critical])<=50, Yellow(),
lightRed()))
For qliksense, it's a good way and the most simple.

Re: Multiple If/than color expressions
julien saint maxent Feb 3, 2015 3:52 PM (in response to William Wagner)or try this:
if (Sum ( [ISSUES P1Critical] ) <10, lightgreen(),
if( Sum ( [ISSUES P1Critical])>50, lightRed(),Yellow(),))
this expression works with <10 or >50.
Sorry for my english

Re: Multiple If/than color expressions
William Wagner Feb 3, 2015 4:44 PM (in response to julien saint maxent)Julien  thank you as well. Its working now. I appreciate it.
