topic Re: How to define Gauge Chart Segment Setup Color in QlikView

How to define Gauge Chart Segment Setup Color

Anonymous — Thu, 24 Sep 2015 12:53:10 GMT

How to define Gauge Chart Segment Setup Color.

Ex. actual amount show red and budget show Green. How to define this two color in Segment Setup.

Thanks.

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Thu, 24 Sep 2015 12:56:52 GMT

Under presentation tab of Gauge object properties, you would be having segment box.

In the top right side of presentation tab, you can set the color as per your req...

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Thu, 24 Sep 2015 13:00:49 GMT

sure. but we need to display color based on calculation.

ex. sum(actual) is red and sum(budget) is Green.

How to achieved on this.

Thanks

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Thu, 24 Sep 2015 13:02:47 GMT

PFA...

Hope this will help!!

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Thu, 24 Sep 2015 13:05:11 GMT

sure. but we need to display color based on calculation.

ex. sum(actual) is red and sum(budget) is Green.

How to achieved on this.

Thanks

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Thu, 24 Sep 2015 13:08:24 GMT

What would be the use of sum(actual) and sum(budget) in gauge chart w.r.t segment??

Could you share some sample data?

Re: How to define Gauge Chart Segment Setup Color

jeroen_wagner — Thu, 24 Sep 2015 14:58:09 GMT

Here an example...

Dynamic color and Dynamic segmentation

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Fri, 25 Sep 2015 05:23:43 GMT

Hi,

PLease find below Screen Shot.

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Fri, 25 Sep 2015 05:33:59 GMT

Yes dynamic color.

Re: How to define Gauge Chart Segment Setup Color

avinashelite — Fri, 25 Sep 2015 05:47:24 GMT

Hi Sathish,

Can you please share the app with sample data. So that we can help you the same

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Fri, 25 Sep 2015 05:55:44 GMT

please find below screen shot, for your reference.

Re: How to define Gauge Chart Segment Setup Color

jeroen_wagner — Fri, 25 Sep 2015 06:18:12 GMT

You can place that formula in the variable

Re: How to define Gauge Chart Segment Setup Color

avinashelite — Fri, 25 Sep 2015 06:33:57 GMT

Sathish, I didn't get your exact requirement...

See in Gauge you can show one value at a time i.e sum(sales) or Sum(budget) but not both at the same time

The Gauge segment if you have define as 1 to 100 then you can say 1 to 50 is RED and 50 to 100 is gree, for eg if sum(sales ) is 10 then it will show in read segment . similarly you need to create separate gauge for sum(budget)

Re: How to define Gauge Chart Segment Setup Color

avinashelite — Fri, 25 Sep 2015 06:35:13 GMT

Hi Sathish,

I didn't get your exact requirement...

See in Gauge you can show one value at a time i.e sum(sales) or Sum(budget) but not both at the same time

Re: How to define Gauge Chart Segment Setup Color

avinashelite — Fri, 25 Sep 2015 06:36:46 GMT

I didn't get your exact requirement...

See in Gauge you can show one value at a time i.e sum(sales) or Sum(budget) but not both at the same time.

The Gauge segment if you have define as 1 to 100 then you can say 1 to 50 is RED and 50 to 100 is gree,

for eg if sum(sales ) is 10 then it will show in read segment . similarly you need to create separate gauge for sum(budget)

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Fri, 25 Sep 2015 06:54:52 GMT

Thanks for Support.we will do the Same.

Re: How to define Gauge Chart Segment Setup Color

avinashelite — Fri, 25 Sep 2015 07:30:24 GMT

if you have got the answer , please mark the correct answer and close this thread

Re: How to define Gauge Chart Segment Setup Color

jeroen_wagner — Fri, 25 Sep 2015 07:37:44 GMT

Look at the example I sent you Yesterday Sathishkumar

(Presentation tab)

Color: RGB(254*($(vValue)/100),150,150)

Segment2 Lower limit: $(vValue)

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Fri, 25 Sep 2015 08:42:01 GMT

Hi Arvinsh,

we can't fix 1 to 50 is red an 51 to 100 is Green.this value floating.In this value displayed by calculation.

Ex:

Actual : 100

Budget :150

Gauge Chart Needle Show 75% this is ok.

We need to display Lower Bound Color, Then 75% display red color and 75 to 100% Green Color.

I think this is better understanding.

Thanks.

Re: How to define Gauge Chart Segment Setup Color

Anonymous — Fri, 25 Sep 2015 08:43:45 GMT

No.we need to provide lower bound value based on Calculation.

Ex:

Actual : 100

Budget :150

Gauge Chart Needle Show 75% this is ok.

We need to display Lower Bound Color, Then 75% display red color and 75 to 100% Green Color.