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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Color lines with expression, line chart

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

Labels (1)
1 Reply
Anonymous
Not applicable
Author

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.