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

Set color by expression (2 measures) - line chart

Hi,

I am trying to set green for "Cumplido" (Compliment) and red for "Cancelado" ("Canceled").

My measures are:

Cumplido:

SUM(FLAG_CUMPLIDO)

Cancelado:

SUM(FLAG_CANCELADO)

About the data:

If FLAG_CUMPLIDO = 1 then FLAG_CANCELADO = null and if FLAG_CANCELADO = 1 then FLAG_CUMPLIDO = null

Anyone has solved this kind of problem?

Labels (1)
4 Replies
sunny_talwar

Not sure I understand your issue, can you elaborate or share a sample?

Anonymous
Not applicable
Author

Hi Sunny,

This is my chart:

recorteProblemaSense.PNG

The red line (Cumplido) should be green and the blue (Cancelado) should be red.

I can't set by expression the colours right.

Sorry if my english is bad.

paul_scotchford
Specialist
Specialist

A simple fix is to swap around your measures.

Anonymous
Not applicable
Author

OK... but... how I set the green colour?