Dynamic Colors of Measures

arvindjha2050 — Sat, 16 Nov 2024 06:48:37 GMT

Hello Team,

In Qlik Sense we are using a line chart with 2 measures and we want custom colors.

Below is the script :

Load * Inline [
SurveyYear,SurveyId,Role,Value
2017,1,HR,1
2017,2,Finance,6

2016,1,HR,7
2016,2,Finance,4

];

Dimension : SurveyYear

We have used variable extension with two values ,Value and Count and line chart values should change based on that.

Created a variable named vtest1 with two values Value and Count(Render as Select option)

Measure 1 :

pick(1 + match(vtest1,'Count'),
Sum(Value),
Count(SurveyId))

Measure 2 :

pick(1 + match(vtest1,'Count'),
Sum({$<Role = {'HR'}>}Value),
Count({$<Role = {'HR'}>}SurveyId))

Here we are getting colors blue and red for two measures , how can colors be changed to say green and yellow.

Thanks & Regards,

Arvind

Re: Dynamic Colors of Measures

MohammedMustaq — Sun, 20 Jan 2019 09:28:15 GMT

Hi,,

You can define your own colors to Measures in Qlik Sense.

Go to Master Items >>> Create New Measure>>> Paste your Expression>>>>>Measure Name>>>>Define Measure Color.

Use this Master Item Measure in Charts.

Thanks

Mustaq