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: 
soniasweety
Master
Master

Guage range

Hi all,

I want to show gugae chart based on range

My req below

100% guage should be used but green/yellow/red ranges should be as follows:

Green = 0 to 5%

Yellow = 6% to 15%

Red = 16% to 100%

Red = 16% to 100%

PFA.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

try:

If((Sum([Year Salary])/Sum(total [Year Salary]))<=0.05, Green(),

  if((Sum([Year Salary])/Sum(total [Year Salary]))<=0.15, Yellow(), red()))

Capture.PNG

View solution in original post

9 Replies
tresesco
MVP
MVP

Like this?

Capture.PNG

soniasweety
Master
Master
Author

Thanks Tres,

But if want through an Expression how can i achieve this?

suppose same values for background colour  ?how can i write the expression?

tresesco
MVP
MVP

Not really clear to me. Please explain a bit more, may be with a case.

soniasweety
Master
Master
Author

i want to show the colour  based on range which i mentioned above.  for that i need to write IF condition?

how to do ?

like below:

if(sum(sales  

Green = 0 to 5%

Yellow = 6% to 15%

Red = 16% to 100%

)                     i need to  IF condition.

rubenmarin

Hi sony, If you want all of the same color you can keep only 1 segment and use conditional color to set the color of the segment, the conditional color expression can be:

If(expression<0.05, RGB(0,255,0),

If(expression<0.15, (255,255,0), RGB(255,0,0)))

tresesco
MVP
MVP

In the bar chart, right?

soniasweety
Master
Master
Author

yes tres.

tresesco
MVP
MVP

try:

If((Sum([Year Salary])/Sum(total [Year Salary]))<=0.05, Green(),

  if((Sum([Year Salary])/Sum(total [Year Salary]))<=0.15, Yellow(), red()))

Capture.PNG

soniasweety
Master
Master
Author

Thnks. its working fine