Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Gauge chart color code based on if condition - Qlik Sense

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?

11 Replies
caio_caminoski
Creator
Creator

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
Creator III
Creator III
Author

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