Color lines with expression, line chart

Anonymous — Sat, 16 Nov 2024 08:58:24 GMT

The measurements added to the line chart are

avg({<signal={"AA"}>} [Measurement])

avg({<signal={"BB"}>} [Measurement])

avg({<signal={"CC"}>} [Measurement])

avg({<signal={"DD"}>} [Measurement])

And dimension date. This works fine and I get four lines one for the measurements corresponding to each signal name.

The i try to color them by expression since I want to customize the colors. This is where I get stuck. I've tried the following:

if(([signal]='AA'), [Measurement]= red(),

if(([signal]='BB'), [Measurement]=green(),

if(([signal]='CC'),[Measurement]=black(),

if(([signal]='DD'),[Measurement]=yellow(),blue())

)

(this one I also tried with RGB code. and without the "[Measurement]=" part

and

if((avg({<signal={"AA"}>} [Measurement])), red(),

if((avg({<signal={"BB"}>} [Measurement])), green(),

if((avg({<signal={"CC"}>} [Measurement])'),black(),

if((avg({<signal={"DD"}>} [Measurement])), yellow(),blue())

)

and

pick(WildMatch((avg({<signal={"AA"}>} [Measurement])),

(avg({<signal={"BB"}>} [Measurement])),

(avg({<signal={"CC"}>} [Measurement])),

(avg({<signal={"DD"}>} [Measurement]))),

red(),

blue(),

green(),

yellow()

)

and some other variants on these.

Would be so thankful for help

Re: Color lines with expression, line chart

Anonymous — Thu, 07 Dec 2017 15:36:22 GMT

I realized I might be able to create master measurements to do what I wanted but I can't seem to find how to color master measurements in Qlik Sense 3.0

Does anyone know if that is possible else my original question stands.

topic Color lines with expression, line chart in App Development

Color lines with expression, line chart

Re: Color lines with expression, line chart