topic Re: Re: color background in linear gauge in QlikView

color background in linear gauge

Anonymous — Thu, 17 Apr 2014 19:59:18 GMT

Hello,

I have a table with linear gauges. I set up color segment by variable orderIDColor.

It shows light gray color by default, but when I select any value from orderIDColor or variable itself, it shows right color.

Where is my mistake?

Thanks,

Re: color background in linear gauge

MK_QSL — Thu, 17 Apr 2014 20:28:57 GMT

Expression Tab

Gauge Setting

Segments Setup

Color

Define Calculated Color as

IF(GetSelectedCount(orderIDColor)=0,RGB(3,135,171),orderIDColor)

Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 15:24:34 GMT

Hi Manish,

It doesn't work, it shows blue color for all of them, but if I select any tag, then it shows right color.

Thanks for helping me.

Re: Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 17:37:24 GMT

you can achieve this without having to go the gauge chart route as i am unable to change the background either. not sure why that would not work.

but check attachment...not clean in terms of making it but visually similar results.

Re: color background in linear gauge

whiteline — Tue, 22 Apr 2014 17:49:57 GMT

Hi.

It's common problem. The expressions in gauge preferences is calculated once for the entire chart.

So that you can't set different min/max for segments refer to dimension values.

Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 17:58:22 GMT

So other words my problem won't be resolved.

Re: Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 18:07:25 GMT

did you see my response above? there is a work around!

Re: Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 18:21:57 GMT

It works, but in my case. I need to switch between channel / campaign. It's difficult to match all rows and bars.

Some clients have more 50 campaigns and 10 channels. Web view has small difference in view.

Thanks for reply.

Re: color background in linear gauge

whiteline — Tue, 22 Apr 2014 19:01:32 GMT

Hi.

You can try to redesign it.

For example, you can use =orderIDColor as a background color for the gauge expression to colorize the cell background.

Then you can make the gauge segment transparent and keep the only needle without filling (toggle hide boundaries an outlines also).

It depends on the message you're trying to send.

Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 19:11:36 GMT

Like this?

Re: color background in linear gauge

whiteline — Tue, 22 Apr 2014 19:22:46 GMT

Perfect 😃

It would be great to fill the right part of each cell, but I guess it's impossible.

There is always a true breakthrough approach: Create a set of tiny columns and fill the background correspondingly.

You get discrete results (ranking) but in post cases there is no difference between 5.8 and 6.1 especially that you have shown the numbers.

Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 19:36:05 GMT

If possible to add a condition like

10-avg(aaa) and set white color for this segment

I didn't understand your idea Create a set of tiny columns and fill the background correspondingly.

Cheers,

Re: color background in linear gauge

whiteline — Tue, 22 Apr 2014 20:51:52 GMT

You can create for example 10 squares (expression columns) instead of one rectangle (gauge).

Then you can colorize the corresponding amount of squares.

Re: color background in linear gauge

Anonymous — Tue, 22 Apr 2014 20:59:03 GMT

could you give an example...i have a very similar requirement that is coming up and this will be very helpful.

Re: Re: color background in linear gauge

whiteline — Wed, 23 Apr 2014 05:42:17 GMT

Hi.

Here some scratches.

The approach with dimensions seems more useful and flexible to me, but it has some limitations.

The expressions can be aligned more precisely but it is not so easy to maintain.

If the design and the discreteness is known you can prepare a set of images and use them with one expression, although without color changes.

Re: color background in linear gauge

Anonymous — Wed, 23 Apr 2014 13:58:26 GMT

thank you...interesting approach! will have to keep this in mind for my requirement.

Re: color background in linear gauge

Anonymous — Wed, 23 Apr 2014 19:33:31 GMT

Interesting idea.

Thanks for helping.