Color by Expression

Klgibson — Wed, 19 Jan 2022 00:31:20 GMT

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

topic Color by Expression in Search the Community

Color by Expression