Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

timorbit
New 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

Re: Color formula

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?

wassim1988
New Contributor III

Re: Color formula

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.

timorbit
New Contributor III

Re: Color formula

No I have no further Filters or other selections.

timorbit
New Contributor III

Re: Color formula

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

Re: Color formula

What is your chart expression?

timorbit
New Contributor III

Re: Color formula

Target Expression

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

Actual Expression

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

Are my both Expressions.

Re: Color formula

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

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

wassim1988
New Contributor III

Re: Color formula

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

timorbit
New Contributor III

Re: Color formula

in multi color I have no black possible

Community Browser