topic Re: Gauge problem in QlikView

Gauge problem

johnan — Wed, 13 Nov 2019 16:38:24 GMT

Hi, i want the gauge to show from right to left with filling.

Red colour on left side and green on the right.
If it is 0 in ToLoad then the gauge will be at bottom green to right

If load is full (Like 105 ) show bottom red on left side.

John

Stoyan_Terziev — Wed, 13 Nov 2019 17:10:36 GMT

Hi Johnan,

Attached is solution.

Basically:

1) Change formula of measure to:

sum(Total Pall)-(sum(Pall)-Sum(Lastat))

2) change sequence of segments

3) change mode to 'Show needle'

Results:

I hope I got right what you try to achieve.

Kind regards,

S.T.

johnan — Wed, 13 Nov 2019 17:14:53 GMT

Thanx, very nice 🙂

johnan — Thu, 14 Nov 2019 06:15:58 GMT

Hey, i noticed, shouldn't 105 be at the bottom?

Stoyan_Terziev — Thu, 14 Nov 2019 09:36:47 GMT

Hi Johnan,

You should be able to control the sorting with the Sort panel of the chart properties.

Let me know if you'll need help with that.

Kind regards,

S.T.