topic Re: displaying negative values in Gauge chart in QlikView

displaying negative values in Gauge chart

Mon, 30 Jun 2014 16:19:43 GMT

i am trying to show minus values in Gauge chart. at present i am displaying the positive values as the below shown image (which is in blue)

is there any way of showing the minus (negative) values as shown in the second image(shown in orange)??

if some one could help me in this i really would appreciate... thank you in advance

Re: displaying negative values in Gauge chart

mphekin12 — Mon, 30 Jun 2014 17:12:56 GMT

Maybe try using the fabs() function. This will convert the negative value to a positive one so that the chart will render. You can then make the color in the Presentation tab a Calculated color, aqua for positive and orange for negative.

Hope this helps.

Re: displaying negative values in Gauge chart

mphekin12 — Mon, 30 Jun 2014 17:18:12 GMT

Here is an example.

Re: displaying negative values in Gauge chart

Tue, 01 Jul 2014 04:48:44 GMT

hi mphekin12

i am using a personal edition. will you be able to send me some screen shots plzz

Re: displaying negative values in Gauge chart

Tue, 01 Jul 2014 05:34:52 GMT

In Presentation tab give minimum guage setting as -1 and maximum as 1

Re: displaying negative values in Gauge chart

Anonymous — Tue, 01 Jul 2014 05:51:28 GMT

Hi, Try below,

Segment 1 = 0%

Segment 1 Color = Orange

Segment 2 = 85%

Segment 2 Color = Transparent

Center Angle = 75 degree

Angle Span = 360 degree

PS: Your expression should be 1 i.e 100% always otherwise this will not work.

Hope this helps you

Re: displaying negative values in Gauge chart

Tue, 01 Jul 2014 07:45:29 GMT

the thin is i am am taking the value from an equation

=if(F=0,

num((sum( Actual)

)

sum( Budget),'##0.##'&'%'),

num((sum( FinActual)

)

sum( Budget),'##0.##'&'%'))

the positive values can be seen but not the negative values

Re: Re: displaying negative values in Gauge chart

mphekin12 — Tue, 01 Jul 2014 12:14:02 GMT

Will this screen shot work for you?