Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bijoylalu
Contributor

Color for a limit area based on a condition in a Gauge

Hi,

          I have a Gauge Chart, for which I have set a limit. Is there any possibility to set the color for a limit area in the gauge based on a condition??

         For instance, I have two Variables(ACTUAL and BUDGET), which generates values based on selection. I set a limit in the gauge using an expression, which identifies whether ACTUAL or BUDGET applies to the limit. If the limit is BUDGET, the area in Gauge from the limit to MAX should be green and if ACTUAL is the limit, then the area from the limit to MAX should be red.

         I am attaching the screenshot of my scenario,(Selection values are specified below each)   

         01.JPG

           02.JPG

          I have kept a KPI to show the variance for the related items(In another way, my requirement is like when the KPI is green, i want the area in graph to be green and if the KPI is red, i want the area in graph to be red(by default its showing green))

     Attaching the qvf for the same also.    

11 Replies
brunobertels
Valued Contributor

Re: Color for a limit area based on a condition in a Gauge

Hi

Gauge shart does'nt support custom colors

shaimamahmoud
New Contributor III

Re: Color for a limit area based on a condition in a Gauge

I selected a Cauge

> go to > Appearance > Presentation >

- Select Use segments

- Drag The Scale (1) to customize your GOAL

- Clik the area after the threshold point to give it a color ,and the area below threshold to give it another color

- Select Gradient (2)  to be Grading between the two colors.

- But Unfortunatly there is no option to color it by expression

cauge.PNG

Does this answer your Question ???

bijoylalu
Contributor

Re: Color for a limit area based on a condition in a Gauge

Hi shaimamahmoud,

          Thanks for your response, I appreciated.

          Actually setting up the Gradient will not suit for my requirement. I want it to change the color of the area, from RED / GREEN depending on the Variable(ACTUAL / BUDGET). 

shaimamahmoud
New Contributor III

Re: Color for a limit area based on a condition in a Gauge

You can also , add multiple ranges and multiple thresholds , or Limits

by pressing button Add Limit as in the pic,

and use Gradient at every Limit on its own

- you can use the expression at the Limit Value , for evaluation value , not for evaluating color,

this makes you do what you want in a reverse way

cauge3.PNG

bijoylalu
Contributor

Re: Color for a limit area based on a condition in a Gauge

Clarifying my requirement.

  I have an expression to set the Maximum Limit of the Gauge, (If ACTUAL is greater, MaxLimit is ACTUAL, if BUDGET is GREATER, MaxLimit is BUDGET).

Now I set a Limit in the Gauge(If ACTUAL is greater, limit is BUDGET, if BUDGET is GREATER, limit is ACTUAL).

  Now about the color of Area in Gauge from Limit to MaxLimit. If the limit is ACTUAL, then color of the area should be RED and if the Limit is BUDGET then the color is GREEN.

The variables and expressions I used for my requirement is there in the .qvf

Highlighted
shaimamahmoud
New Contributor III

Re: Color for a limit area based on a condition in a Gauge

How about adding 2 Limits

Actual and Budget and coloring each one of them

bijoylalu
Contributor

Re: Color for a limit area based on a condition in a Gauge

If we add two limits, then it will be two different areas. Even there won't be any intersected area for both.

shaimamahmoud
New Contributor III

Re: Color for a limit area based on a condition in a Gauge

Limit 1 = MIN (Actual , Budget)

LIMIT2 = MAX(Actaul, Budget)

tkendrick20
Valued Contributor

Re: Color for a limit area based on a condition in a Gauge

Instead of a gauge, you could use a stacked bar chart with a KPI object underneath and get a similar look. For bar charts you can absolutely set the colors of each of the bar segments conditionally.

Community Browser