topic Re: Gauge / Speedometer Chart (Color condition) in QlikView

Gauge / Speedometer Chart (Color condition)

Fri, 22 May 2015 15:03:43 GMT

Hello,

I have to create 3 Gauge / Speedometer Charts with the following coloring requirements for the 3 of them:

1 - The bar should be turn Blue when the variation Value is negative.

2- The bar should be turn Orange when the variation Value is not too hight or too low .

3- The bar should be turn Green when the variation Value is hight.

Can you please help acomplish those, here a picture from the requirement:

Previously, in the color section i wrote the following expression, but it didnt work:

(
(
(
sum(Value)

/
sum({<$(vMonthPreviousYear)>}Value)
)-1
)<0
, rgb(0,255,255), rgb(0,0,0))

Thanks for your help.

ecolomer — Sun, 24 May 2015 08:28:55 GMT

here you have an example

anlonghi2 — Sun, 24 May 2015 16:15:08 GMT

Hi Iuri,

please look at attached app and let me know if it is ok for your needs.

try it assigning values (both negative and positive) to v_expval using the input box.

Best regards

Andrea

Anonymous — Mon, 25 May 2015 05:59:00 GMT

you dont need to write expression under color tab.

you need to define the segments.

if you want only two colors just define one segment

see image.

Thanks

BKC

Fri, 05 Jun 2015 13:50:34 GMT

Thank you anlonghi2,

That approach is closer to my needs.