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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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