Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
MK_QSL
MVP
MVP

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

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

View solution in original post

6 Replies
MK_QSL
MVP
MVP

go to Expression tab

Click on + sign of expression

Write below expression in text color

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

Anonymous
Not applicable
Author

Thank you very much for the response.

Expression is not getting validated at Total with IF condition.

IF(SUM(TOTAL)

MK_QSL
MVP
MVP

Provide your sample apps...

MK_QSL
MVP
MVP

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

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

Anonymous
Not applicable
Author

Thank you, Its working now.

qv_testing
Specialist II
Specialist II

Hi Sandeep,

Better to use in Expression tab,

Click on taggole button,

Write this expression in "Text Color"

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