Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

san_qliklearn
New Contributor II

Visual Cues issue

Hi,

I have created stright table and provided condition to fact field like

Unitcost > 20 (Show in green color)

Unitcost<20 (Show in red)

if you look at the sum(Total)  it also showing in Green color (as like > 20)

How can we limit the color to sum.

Regards,

Sandeep

1 Solution

Accepted Solutions

Re: Visual Cues issue

IF(Dimensionality() = 0, Black(),

  IF(SUM(Cost)>200,Green(),Red()))

6 Replies

Re: Visual Cues issue

go to Expression tab

Click on + sign of expression

Write below expression in text color

IF(SUM(Total) > 20, green(), red())

san_qliklearn
New Contributor II

Re: Visual Cues issue

Thank you very much for the response.

Expression is not getting validated at Total with IF condition.

IF(SUM(TOTAL)

Re: Visual Cues issue

Provide your sample apps...

Re: Visual Cues issue

IF(Dimensionality() = 0, Black(),

  IF(SUM(Cost)>200,Green(),Red()))

san_qliklearn
New Contributor II

Re: Visual Cues issue

Thank you, Its working now.

qv_testing
Valued Contributor

Re: Visual Cues issue

Hi Sandeep,

Better to use in Expression tab,

Click on taggole button,

Write this expression in "Text Color"

IF(SUM(Cost) > 20, green(), red())

Community Browser