topic Re: Visual Cues issue in Qlik Learning Discussions

Visual Cues issue

Anonymous — Tue, 04 Nov 2014 12:54:22 GMT

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

MK_QSL — Tue, 04 Nov 2014 12:58:31 GMT

go to Expression tab

Click on + sign of expression

Write below expression in text color

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

Anonymous — Tue, 04 Nov 2014 13:11:26 GMT

Thank you very much for the response.

Expression is not getting validated at Total with IF condition.

IF(SUM(TOTAL)

MK_QSL — Tue, 04 Nov 2014 13:19:58 GMT

Provide your sample apps...

MK_QSL — Tue, 04 Nov 2014 14:24:01 GMT

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

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

Anonymous — Tue, 04 Nov 2014 14:27:13 GMT

Thank you, Its working now.

Nagaraju_KCS — Tue, 04 Nov 2014 14:29:07 GMT

Hi Sandeep,

Better to use in Expression tab,

Click on taggole button,

Write this expression in "Text Color"

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