Gauge chart color code based on if condition - Qlik Sense

[rammuthiah]

I have calculated dimension, I want to show colour based on condition,

if Calculated value > than 0.80, colour should be green()

if Calculated value < than 0.80, colour should be red()

Also, How to give range and limits using segments?

[caio_caminoski · Accepted solution]

Hi Ram,

so, following the images I sent before you would have sth like:

First Dimention

=1 (or any text you would like)

Second Dimentions

=Valuelist(1, 2) (or any two names you would like

Measure:

if( valuelist(1,2)=1

     ,[Your Expression that returns a number between 0 and 1]

    , 1 - [Your Expression that returns a number between 0 and 1]

    )

Color Expression:

if( (valuelist(1,2)=1) and ([Your Expression that returns a number between 0 and 1]<0.8)

     , Red()

     ,if( valuelist(1,2)=1

          ,Green()

         ,LightGray()

    )

)

[rammuthiah]

Thank you Once Again, Caio. It's working now.