Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?