topic Re: Expression Background Color based on Expression Name in QlikView

Expression Background Color based on Expression Name

NancyG — Sat, 16 Nov 2024 00:47:02 GMT

I have a Dimension [ORG] that contains the different organization in my work area, one of them is HR. I have an associated file that designates standard colors in RGB format that I use to designate colors in graphs for each organization.

When [ORG] is a dimension in the plot, and the expression like sum(hours), I use a series of if statements, if([ORG]='HR', RGB(ORED,OGREEN,OBLUE), as the Background color expression to set the color for each [ORG].

My current quandary... I'm setting the Expression label equal to Organization's name, e.g. HR, each expression in the plot finds the number of people in that Organization, count({<ORG={'HR'}>}DISTINCT NAMES). I'd like to keep the colors consistent with the plots using [ORG] as a dimension. How can I link the Expression name, HR, to the color codes associated with [ORG] = 'HR'

Thanks.

Re: Expression Background Color based on Expression Name

kaushiknsolanki — Fri, 24 Apr 2020 18:27:06 GMT

HI,

You should use the Master Library to define colours for your dimension and measures.

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Colors/assigning-colors-to-dimension-values.htm

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Colors/assigning-colors-to-measure-values.htm

Re: Expression Background Color based on Expression Name

Brett_Bleess — Wed, 20 May 2020 21:21:31 GMT

Here is a Design Blog post that may be another option:

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

Regards,
Brett