Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Klgibson
Contributor
Contributor

Color by Expression

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)

Klgibson_1-1642551836311.png

 

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". 

Klgibson_0-1642551126014.png

=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

0 Replies
Community Browser