Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tim_m
Partner - Contributor III
Partner - Contributor III

Color formula

Hi Folks,

my color Expression if(SUM({<[Account]={'Product B'}>}VALUE)<0, red(),black())

Please can you help me, why the following negative values are black colored, although my Expression is defined in red?

And how it is possible to color the line in a different color? This is my Plan-Line. This color alters if I use the expression above. It is possible?

Thank you!

9 Replies
sunny_talwar

What is the expression that you use for your chart? Do you have other set analysis that ignore some other selections when plotting the chart?

Anonymous
Not applicable

You have another set that force the black color, it may be in the chart parameter.

Try to put only that expression in a new table.

tim_m
Partner - Contributor III
Partner - Contributor III
Author

No I have no further Filters or other selections.

tim_m
Partner - Contributor III
Partner - Contributor III
Author

Please can you explain where I find this setting? In Colors I can set the black color but I want to set the line in red

sunny_talwar

What is your chart expression?

tim_m
Partner - Contributor III
Partner - Contributor III
Author

Target Expression

SUM({<[Account]={'Produkt B'},SALES={'targeted amount'}>}Value)

Actual Expression

SUM({<[Account]={'Produkt B'},SALES={'actual amount'}>}Value)

Are my both Expressions.

sunny_talwar

Which one is represented for the bar? actual? May be try this

if(SUM({<[Account]={'Product B'},SALES={'actual amount'}>}VALUE)<0, red(),black())

Anonymous
Not applicable

where you did put your color expression. have you another color expressions?

tim_m
Partner - Contributor III
Partner - Contributor III
Author

in multi color I have no black possible