topic Re: Multi Colored Linear Gauge in QlikView

Multi Colored Linear Gauge

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

Please find the attached QVW and data set.

In the above straight table i would like to add different colors for each country bars.

For example,

Country1 - Blue

Country2 - Brown

Country3 - Black

Country4 - Red

I tried giving a conditional statement in the gauge properties,

But it is not working. Still showing a single color (green).

Is there a way to show different colors for each country.

Thanks

Koushik

Re: Multi Colored Linear Gauge

HirisH_V7 — Sat, 12 Mar 2016 12:23:45 GMT

Hi ,

Check this,

By Changing Back ground Color of your Expression,

and Making Linear Back Ground Color Transparent $()

HTH,

PFA

Hirish

Re: Multi Colored Linear Gauge

Anonymous — Sat, 12 Mar 2016 15:32:57 GMT

hirishv7‌

Thanks for the reply.

Is it possible to change green color portion of the bar.

My requirement is shown in the below image,

Please let me know if more information is needed.

Thanks

Koushik

Re: Multi Colored Linear Gauge

Kushal_Chawda — Sat, 12 Mar 2016 15:55:03 GMT

I don't think that we can provide multiple color in Mini chart setting. But there is work around. You can do something like below

You can set the back ground color for countries. In mini chart setting choose the indicator as Needle.

Make sure that color should be light so that black needle will be visible.

Re: Multi Colored Linear Gauge

MarcoWedel — Sat, 12 Mar 2016 22:55:58 GMT

Hi,

I guess you might not be able to define the linear gauge colours per country as this colour expression is not evaluated per dimension value, but you could define background colours per country (like Hirish already demonstrated) and use some transparent black as common linear gauge colour to get a darker shade of the background colours:

hope this helps

regards

Marco