topic Re: Gauge variable color mapping in QlikView

Gauge variable color mapping

Fri, 21 Mar 2014 17:57:22 GMT

Hi -

I am trying to have different sections of a gauge in a pivot table display bars in different colors. The attached screenshot shows 3 segments (We call a segment 'Tag Group' in the database). And here is the code I am using to make the color variable:

=IF([Tag Group]='All Households', red(),

IF([Tag Group]='Age Range', blue(),

IF([Tag Group]='Consumer Creditworthiness', yellow(),

IF([Tag Group]='Household Income', green(),

IF([Tag Group]='Make/Model', blue(),

LightGray())))))

But the displayed color is always coming out light gray.

Does this function work in QV, and if so then what am I doing wrong?

Thank you!

Re: Gauge variable color mapping

shree909 — Fri, 21 Mar 2014 18:06:28 GMT

HI i think its possible,

Could you please post a sample file with limited data.

The other way is try to add different segments and try to place the lower value as the as some numeric number.

Thanks

Re: Gauge variable color mapping

jerem1234 — Fri, 21 Mar 2014 18:07:12 GMT

Try wrapping Tag Group in the only function:

=IF(only([Tag Group])='All Households',......

IF(only([Tag Group])='Age Range',......

.....

Hope this helps!

Re: Gauge variable color mapping

Fri, 21 Mar 2014 18:28:58 GMT

Nope, didn't change anything.

Re: Re: Gauge variable color mapping

Fri, 21 Mar 2014 18:32:13 GMT

shree ana - Small sample attached. your help is greatly appreciated!

Re: Re: Re: Gauge variable color mapping

SunilChauhan — Fri, 21 Mar 2014 18:49:07 GMT

PLEASE FIND ATTACHED

HOPE THIS HELPS

Re: Gauge variable color mapping

jerem1234 — Fri, 21 Mar 2014 18:53:59 GMT

You won't be able control the color of the bar based on dimension, because its an all or nothing deal. It works on the whole set without regard to dimensions.

Hope this helps!

Re: Re: Re: Gauge variable color mapping

Fri, 21 Mar 2014 19:05:11 GMT

What did you change? The logic in Properties>Expressions>Gauge Properties>Color Area>Calculated looks the same as what I sent.

Re: Re: Re: Re: Gauge variable color mapping

SunilChauhan — Fri, 21 Mar 2014 19:08:56 GMT

Gauge expression background color

i have used

=IF([Demo Group]='All Households', red(),

IF([Demo Group]='Age Range', blue(),

IF([Demo Group]='Consumer Creditworthiness', yellow(),

IF([Demo Group]='Household Income', green(),

IF([Demo Group]='Make/Model', blue(),

LightGray())))))

see the attched image

Re: Re: Re: Gauge variable color mapping

Fri, 21 Mar 2014 19:37:18 GMT

This ends up with the inverse of the desired result. Thank you anyway!

Re: Re: Re: Gauge variable color mapping

Fri, 21 Mar 2014 19:38:12 GMT

@jerem1234 - Unfortunately you're probably right, what I want to do cannot be done in QV. Thanks anyway!

Re: Gauge variable color mapping

pgrenier — Tue, 22 Apr 2014 20:11:11 GMT

Hello Ron,

Unfortunately, the gauge element shall reuse the same color for each row. You can try putting the following expression in the color definition Color(RowNo()) to confirm this.

Regards,

Philippe

Re: Gauge variable color mapping

pgrenier — Tue, 22 Apr 2014 20:27:49 GMT

Ron,

If I may propose a workaround, you could invert the color use and define the color of the background and use a white or pale color overlay to indicate where the values are at.

Please find attached the modified example file.

Regards,

Philippe

Re: Gauge variable color mapping

Anonymous — Tue, 22 Apr 2014 21:00:56 GMT

interesting solution Philippe....exact same requirement discussion going on in this thread for reference...couple of work arounds in it

color background in linear gauge