Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Gauge Chart

problem.PNG

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.

4 Replies
Highlighted

Re: Gauge Chart

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()))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

Re: Gauge Chart

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 %)

Highlighted
Creator III
Creator III

Re: Gauge Chart

Thanks Anil. Its working.

Highlighted

Re: Gauge Chart

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)