topic Re: Traffic Light Gauge not displaying correct colours in QlikView

Traffic Light Gauge not displaying correct colours

Tue, 29 Jul 2014 11:32:17 GMT

Hi everyone.

When my negative values becomes too low, it seems the gauge does not still show the color red but instead grey. If you look at my screen shots they do work in many instances but it is not consistent. I also played around with the min and max tollerances but nothings helps to resolve. You will see that my variable is basically the variance percentage which is also indicated in the screen shot and using the same logic in a visual cue, it seems to shade correctly.

Would appreciate your help.

Thank you.

Re: Traffic Light Gauge not displaying correct colours

maxgro — Tue, 29 Jul 2014 11:38:39 GMT

remove <0 and check your variable,

lower bound should be a number, example

0.0

Re: Traffic Light Gauge not displaying correct colours

tobias_klett — Tue, 29 Jul 2014 11:45:05 GMT

Hi,
the gauge setting applies always to the whole column. It is not read differently for each line.

This applies to color and boundries.

Hope this helps.

Tobias

Re: Traffic Light Gauge not displaying correct colours

Tue, 29 Jul 2014 12:08:52 GMT

Hi Tobias.

Yes, I'm aware but I'm actually wanting it to be consistent as you say.

Thanks.

Re: Traffic Light Gauge not displaying correct colours

Tue, 29 Jul 2014 12:13:30 GMT

Hi.

I tried this originally but to no avail.

I'm trying to upload my qvw but alas I once again have the issue of not being able to do so since I cannot see the advanced editor option on my side. It works intermittently..

Not sure how else I can explain/show my issue at the moment without being able to upload.

Re: Traffic Light Gauge not displaying correct colours

tobias_klett — Tue, 29 Jul 2014 12:28:39 GMT

Hi QlikAsh13,

the expression "vVar%<0" is a boolean (true/false). The boolean values are "0" when false and "-1" when true. In your case it seems to be false and therefore "-1".
The %Values lower 100% are lower "-1" and the %Values between 0% and -100% are higher "-1" and lower "0". Since your lower bound starts with "-1" there is no color for values lower -100%, and therefore they are grey.

Hope this helps
Tobias

Re: Traffic Light Gauge not displaying correct colours

Tue, 29 Jul 2014 19:02:52 GMT

Hi Tobias.

Thank you so much for your explanation. Well this was part of the issue. I could be wrong but the impression that I'm getting is that one must 'know' the possible min and max values in order for this to work. For example my data so far goes as low as -600%. Therefore by having set my lower bound initially as 0, I assumed that QV would then know that any value less than 0 must be red as is the case with visual cues. However, it did not seem so which was when I then tried the variable route which as you pointed out has the anomaly of the boolean check. Therefore I tried manually inserting values. Only when I said the lower bound must be -6 and min gauge value also -6 did it work. As I say I could be wrong but this is sort of hard coding values and what happens if I later have a -850%.

Thanks.

Re: Traffic Light Gauge not displaying correct colours

Tue, 29 Jul 2014 19:29:29 GMT

as colorblind person traffic light gauges can be hard to read, make sure to consider us

Re: Traffic Light Gauge not displaying correct colours

tobias_klett — Wed, 30 Jul 2014 06:20:07 GMT

Hi QlikAsh13,

it is simple to just put -100 into it which would be ok till -10.000% but if you want it to start at your min which is important when you use linear gauge instead of traffic light you can use the aggr() combined with min() to get your min value for the setting. Example:
=min(aggr( ExpressionXY, Department))

Since you are using a circular group as dimension you could make department dynamically like this:

=min(aggr( ExpressionXY, $(=GetCurrentField(GroupXY))))

You can test these expressions within a textbox to check if the result is your expected figure.

Hope this helps
Tobias

Re: Traffic Light Gauge not displaying correct colours

tobias_klett — Wed, 30 Jul 2014 19:02:12 GMT

Did you try the aggr()? Would be interesting to hear if it worked?

Re: Traffic Light Gauge not displaying correct colours

Thu, 31 Jul 2014 09:51:30 GMT

I'm also not fond of the red/green gauges for this reason but clients often want it that way..

Re: Traffic Light Gauge not displaying correct colours

Thu, 31 Jul 2014 09:53:35 GMT

Hi!

Sorry for the delayed response. I tried it out now. It works in a text box but not in the gauge itself. I can't see why is wouldn't work. I'd like to send you the qvw but attaching files s a problem on my side as I cannot see Advanced Editor.

Sometimes when others attach a file on the post, then it allows me to attach a file in return (my theory). So maybe if you want to attach a test file then I can send it to you perhaps.

Thank you.

Re: Traffic Light Gauge not displaying correct colours

tobias_klett — Thu, 31 Jul 2014 12:15:05 GMT

Hi,
this is interesting. But I have an editor which only alows me to upload pictures and videos into the post. 😞
Tobias
I'll make you my friend. So you can see my E-Mail.

Re: Traffic Light Gauge not displaying correct colours

mr_ramshini — Sun, 07 Sep 2014 10:47:22 GMT

I have a problem

How i can set color's lights in traffic lights?

thanks