topic Re: Linear Gaugue - Dynamic Segment Color in QlikView

Linear Gaugue - Dynamic Segment Color

Mon, 13 Apr 2015 18:04:15 GMT

Hi QV Experts,

I have a simple requirement of a Straight Table with Expression as a Linear Gauge. For e.g.

Data Example

Phase Project %Complete

PROD A 0.5

PROD B 0.75

QA C 0.35

QA D 0.25

I would Like to show %Complete as a Linear Gauge with only 1 segment (Lower Bound =0, Fill to Value). However, I would like the color of the Linear Gauge Fill to vary based on Phase. for example - Green for PROD and Orange for QA.

I tried few ways but not working and making me feel it is a Bug. Appreciate your responses.

Thank You,

Ganesh

Re: Linear Gaugue - Dynamic Segment Color

maxgro — Mon, 13 Apr 2015 19:47:34 GMT

I think the linear gauge color in a chart is one color (always the same)

Re: Linear Gaugue - Dynamic Segment Color

Tue, 14 Apr 2015 07:58:29 GMT

Yes, I had kinda the same task lately, I guess you can't dinamically change gauge color

Re: Linear Gaugue - Dynamic Segment Color

Anonymous — Tue, 14 Apr 2015 08:12:08 GMT

Could you display how you tried to solve it?

I have used this in a gauge with this expression on the first segment color

=if(Sum(Margin)/Sum(LineSalesAmount)>=0.15, $(vABCColor_Green1), $(vABCColor_Red))

The second segment is simply Grey. The two segment boundries are 0 for the first one and this for the second one

=Sum({$<CYTDFlag={'1'}, Year=, Quarter=, Month= >}Margin)/Sum({$<CYTDFlag={'1'}, Year=, Quarter=, Month= >}LineSalesAmount)

I have not tried this in a line chart but it should work the same way . You should be able to adjust the first if statement to chose the colors you want.

Re: Linear Gaugue - Dynamic Segment Color

Tue, 14 Apr 2015 13:55:22 GMT

Hi Nils, Thanks for the reply but It doesnt seem to work.

I tried to display by writing an expression like this in the segment color expression -

If (Phase='PROD', red(), yellow())

Is it possible to attach the qvw of the expression you mentioned which is working for you.

Ganesh