Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

hopkinsc
Valued Contributor II

Text in chart expression help

Hi,

I have the following expression as 'Text in Chart'

=num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD))

I want the background of the text to go red if the result is a negative.

Can anyone help me on how to do this using a calculated background please?

1 Solution

Accepted Solutions
MVP
MVP

Re: Text in chart expression help

Use calculated Base color in your Color area dialog:

=if(

num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD)) < 0,

,lightred()

)

1 Reply
MVP
MVP

Re: Text in chart expression help

Use calculated Base color in your Color area dialog:

=if(

num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD)) < 0,

,lightred()

)

Community Browser