Gauge Chart

[rkpatelqlikview]

Hi All,

Here is the value 56.  If Value is <20 scale should be in Green and values is in between 20 and 50 it should be Yellow.

How can we get the value. If >50 scale  should be ini Red color.

How to solve this one. Can any one explain please this one. Thanks in advance.

[Anil_Babu_Samineni]

You can assign this for slider expression as

If this is an percentage

If(sum(value) < 0.2, green(),

If(sum(value) > 0.2 and sum(value) <0.5, yellow(), red()))

If it is number

If(sum(value) < 20, green(),

If(sum(value) > 20 and sum(value) <50, yellow(), red()))

[dieterdec]

The color split of the bar is set standard equal: each of your 3 colors fills 33% of the bar.

You can alter the lower bound of each segment in the chart properties - presentation - segment setup

yellow lower bound = 20 (or as Anil Babu replied: 0.2 if you're using percentage)

red lower bound 50 (or 0.5 for %)

[rkpatelqlikview]

Thanks Anil. Its working.

[Anil_Babu_Samineni]

Glad we were able to offer you, Please close this thread by flag "Correct Answer" using Qlik Community Tip: Marking Replies as Correct or Helpful