topic Re: Guage range in QlikView

Guage range

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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%

PFA.

Re: Guage range

tresB — Wed, 30 Nov 2016 10:14:55 GMT

Like this?

Re: Guage range

soniasweety — Wed, 30 Nov 2016 10:22:13 GMT

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?

Re: Guage range

tresB — Wed, 30 Nov 2016 10:25:34 GMT

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

Re: Guage range

soniasweety — Wed, 30 Nov 2016 10:28:38 GMT

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.

Re: Guage range

rubenmarin — Wed, 30 Nov 2016 10:32:49 GMT

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

Re: Guage range

tresB — Wed, 30 Nov 2016 10:36:06 GMT

In the bar chart, right?

Re: Guage range

soniasweety — Wed, 30 Nov 2016 10:37:38 GMT

yes tres.

Re: Guage range

tresB — Wed, 30 Nov 2016 10:48:44 GMT

try:

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

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

Re: Guage range

soniasweety — Wed, 30 Nov 2016 10:49:38 GMT

Thnks. its working fine