Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am running into a problem fairly consistently with Qlik Sense - Color by Expression. The below chart has a color by expression which uses 5 different colors for the different groupings that I have identified. These are applied to a stacked bar chart, and the x axis reflects the month in which the orders are scheduled to ship.
Orders On Hold = Red - RGB(255,121,121)
Orders Dropped for Delivery = Green - RGB(169,208,142)
Bill Only = Yellow - RGB(255,230,153)
Released-Today/Future Request Dates = Purple - RGB(112,48,160)
Released-Past Due Request Dates = Blue - RGB(142,169,219)
Now the problem (hard to see - above) - One of the data series "Released-Today/Future Request Dates" is populating in Blue and Purple.
See below screenshot which is filtered to only show items that have a "Future Request Date".
=if([Open_Orders.Order Type]='ZDR',RGB(255,230,153),if([Open_Orders.Order Type]='ZCR',RGB(255,230,153),
IF([Open_Orders.Delivery Status]='Open',RGB(169,208,142),
IF([Open_Orders.Credit Status]='Credit Blocked',RGB(255,121,121),IF([Open_Orders.Billing Block]<>' ',RGB(255,121,121),
IF([Open_Orders.Delivery Block]<>' ',RGB(255,121,121),if([Open_Orders.Req Delivery Date]>=Today(),RGB(112,48,160),RGB(142,169,219))))))))
Why isn't this data series always purple?
Thanks in advance...First time poster